Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jamie
Aged Yak Warrior
542 Posts |
 Posted - 2007-05-31 : 05:19:02
|
| hi,I am trying to backup from ServerA to ServerB but recieve this error :BackupDiskFile::CreateMedia: Backup device '\\ServerB\test\dbtest.bak' failed to create. Operating system error = 5(error not found).The SQL I am running against a 2000 ms sql server is :BACKUP DATABASE Northwind TO DISK = '\\ServerB\test\dbtest.bak'I have added my NT account have full control over the test folder and I am connecting to QA to run this SQL using my NT account.What am I doing wrong ?kind regards,jamie |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-31 : 10:06:08
|
| You have to start sql service with domain account that has permission on test share. |
 |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2007-05-31 : 10:16:45
|
| than kyou rmiao.I will try that..Does it need to be the SQL Server Service or the SQL Agent Service ? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-31 : 10:24:53
|
| Run in query analyzer -> SQL Server Service, run as job -> SQL Agent Service. |
|
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2007-06-10 : 07:52:05
|
| hi, I have changed the sql agent service and run the backup as a job but recieve this error :Executed as user: ADDOM\SQLAgent. Cannot open backup device '\\ServerB\test\dbtest.bak'. Device error or device off-line. See the SQL Server error log for more details. [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-10 : 16:08:37
|
| Does ADDOM\SQLAgent have permission to access \\ServerB\test\dbtest.bak? Did you check sql server log for details? |
|
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2007-06-11 : 04:35:37
|
| the account has permissions to the folder.(dbtest.bak does not exist - I am trying to backup to a new file calling it dbtest.bak)SQL log says :BackupDiskFile::CreateMedia: Backup device '\\ServerB\test\dbtest.bak' failed to create. Operating system error = 5(error not found).Is this because the bak file does not exist ?doesn't the sql BACKUP DATABASE NorthwindTO DISK = '\\ServerB\test\dbtest.bak' also create the bak file ?ps, thank you for all your help so far. |
|
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2007-06-11 : 05:06:50
|
| I have just tried backing up to a different server and it worked. so it must either be permissions on the test folder, or I need to use the literal path instead of shares? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-11 : 06:08:56
|
It will be permissions.Log on to the ServerA (e.g. using Terminal Services) using the UserID and Password as-configured for SQL Agent ServiceFrom a Command Prompt type:ECHO xxx > \\ServerB\test\JUNK.$$$change the permissions on ServerB (or Domain Controller) until that works  then try from SQL Server.Kristen |
|
|
|
|
|
|
Error Backing up to another server