May 26, 2011 at 7:45 am
As I am going to schedule Database in maintenance plan for sql server 2000.But the network drive (Map drive) not showing for destination backup path.Pls let me know where it is problem.
May 26, 2011 at 7:49 am
You must put it on a local drive, then copy to network, then delete.
I do this instead of move in case something goes horribly wrong during the move. That way you don't lose the file(s).
May 26, 2011 at 7:59 am
this is not a proper solution
May 26, 2011 at 8:02 am
It's not like you have a choice here...
May 26, 2011 at 6:31 pm
You can backup directly to a network share. To do so, you have to use the UNC path instead of a drive letter. Since SQL Server is a service - it does not know anything about mapped drives.
Now, be forewarned - doing so will take much longer to perform the backup and may fail at any time if there are any glitches in the network. Any interruption from the network will cause the backup process to fail.
The recommended approach is to backup locally and copy the backup files to the network. This is because copying files is not susceptible to the network issues the same way a SQL backup is.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply