August 16, 2010 at 6:45 am
i have a LAN setup were i have a sql database server(system1) webserver (system 2) and all other clients
in my set up when i take the back up using
Backup DATABASE ..................... to DISK....................
i am able to take the back up properly
but in my client location they have the webserver & database server on the same system but still i am not able to take the backup frm the client system across the network setup as i have the LAN set up with mine
i get error msg " cannot open backup device .............................. device error or device offline
i am using SQL 2000
wht setting do i need to check & modify to get the back up
August 16, 2010 at 7:03 am
I don't quite understand.
Are you trying to backup the database across the network to a UNC path? If so, make sure that the SQL Server system account has the correct share and ntfs permissions to the path.
Can you post the backup command that you're running.
August 16, 2010 at 7:14 am
have you read about sp_adddumpdevices....have a look.
----------
Ashish
August 17, 2010 at 12:00 am
Backup DATABASE CRMNET TO DISK ='D:\mydata.dat ' WITH FORMAT,STATS=1
thi is the backupcommand i am using
and th same command exists at the client location also
i am using sql2000
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply