December 8, 2003 at 3:08 pm
How to backup database onto network shared drives in SQL 2000?
We’d like to backup our database onto one of the network shared drive without successful. Does anybody know how to do it?
Thanks,
Harrison
Harrison Lee
HCL618@yahoo.com
908-219-5435
December 8, 2003 at 3:10 pm
You must first create a backup device that points to your network share, and then backup your database to the backup device you created.
Gregory A. Larsen, DBA
Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:www.sqlservercentral.com/bestof/purchase.asp
Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
December 8, 2003 at 3:22 pm
We can see this network share thru file exploer and can pass any file by copy and past. But while we try to backup db into this NAS, we just can not create this backup device.
We have other network shared drives which can see and access successfully.
We really don't know what happen to this one.
Harrison
212-729-5338
Harrison Lee
HCL618@yahoo.com
908-219-5435
December 8, 2003 at 3:36 pm
Does the MSSQLSERVER service account have access to this network share? Can you see the directory when you execute "master.dbo.xp_cmdshell 'dir <UNC_NAME>"?
Note: replace <UNC_NAME with the appropriate UNC name that relates the the network share for which you are having problems.
Gregory A. Larsen, DBA
Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:www.sqlservercentral.com/bestof/purchase.asp
Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
December 8, 2003 at 4:46 pm
Also any network "drives" you have need to be mapped permanently WHILE YOU ARE LOGGED in as the MSSQLSERVER account. Not using your account.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 22, 2003 at 1:35 pm
I am having the same type of issue. I have a 6.5 database on one server and a 2000 database on another server. The server with 2000 on it has much available space. The server with 6.5 on it has very little avaliable space.
I would like to define a device on 2000 server and backup the 6.5 server to that device. But as I'm new at this, I have not found any resources to explain how to do this.
Any help would be much appreciated!!
-RaeG
December 22, 2003 at 1:56 pm
quote:
Also any network "drives" you have need to be mapped permanently WHILE YOU ARE LOGGED in as the MSSQLSERVER account. Not using your account.
Or you can use xp_cmdshell to map the drive as a step in your backup job.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply