|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
URGENT: Backup to network drive with SQLServer 2005
In SQL2000 I can backup to a mapped network drive (Z: for example) as it is
listed in the backup window (C:, D:, ..... Z:). In SQL2005, drive Z: is not listed and If I try to force it by writing the full path name (z:\mybackup.bak) I shows an error. Any ideas? Note: The service account which SQL2005 runs on has permissions to this share. Thanks! Backing up to a mapped drive on any edition of SQL is an iffy proposition.
UNC names always work. -- Show quoteHide quoteGeoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP "Gaspar" <gas***@gaspar.com> wrote in message news:Ohd8QARSGHA.1236@TK2MSFTNGP11.phx.gbl... > In SQL2000 I can backup to a mapped network drive (Z: for example) as it > is listed in the backup window (C:, D:, ..... Z:). > > In SQL2005, drive Z: is not listed and If I try to force it by writing the > full path name (z:\mybackup.bak) I shows an error. > > Any ideas? > Note: The service account which SQL2005 runs on has permissions to this > share. > > Thanks! > Gaspar wrote:
> In SQL2000 I can backup to a mapped network drive (Z: for example) as it is Have you tried the UNC path?> listed in the backup window (C:, D:, ..... Z:). > > In SQL2005, drive Z: is not listed and If I try to force it by writing the > full path name (z:\mybackup.bak) I shows an error. > > Any ideas? > Note: The service account which SQL2005 runs on has permissions to this > share. > > Thanks! > > Hi
Is the SQL Agent account using the domain admin service account? Show quoteHide quote "Gaspar" <gas***@gaspar.com> wrote in message news:Ohd8QARSGHA.1236@TK2MSFTNGP11.phx.gbl... > In SQL2000 I can backup to a mapped network drive (Z: for example) as it > is listed in the backup window (C:, D:, ..... Z:). > > In SQL2005, drive Z: is not listed and If I try to force it by writing the > full path name (z:\mybackup.bak) I shows an error. > > Any ideas? > Note: The service account which SQL2005 runs on has permissions to this > share. > > Thanks! >  
Other interesting topics
Deadlocks "again"
Move DB by backup/restore or SP_Detach? How to "Grant" a Trigger ??? IN clause with comma seperated values in select query Table comparison Management Studio Question.... what kind of index to use in this situation. Add User to Log-Shipped Database sqlserver 2005 express license Licensing by the month? |
|||||||||||||||||||||||
