August 12, 2003 at 4:22 am
Sorry if this subject has been covered before but I have only just joined this forum and cannot find any refrence to my question, which is.
I want to backup my database files to another machine over the network.
But it is knowing how to setup a new device or choose the mapped drive, is it possible to do what I said above.
I have found refrence to this on MS
(\\Servername\sharename\path\file) but how do I, or should I say where do I put this.
Do I create a new device or something, because when I do an error appears saying the above cannot be found.
Chers.
August 12, 2003 at 8:03 am
You can backup over the network using a UNC name. You don't need to set up a device, you just need to do:-
BACKUP DATBABASE dbname TO DISK='\\servername\sharename\path\file'
SQL Server must be started using an account that has access to the share name. If you start SQL Server using the LocalSystem account, it will not have access to any network resources.
August 12, 2003 at 8:08 am
Cheers m8, that sounds exactly right, I do not have the correct permission on the network.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply