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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-22 : 08:20:05
|
| writes "OK. I am running SQL Server 2000. I am logged onto the domain on this machine. I have a 2nd machine to which I am trying to backup the pubs database (for practice) in preparation for a real (production) backup soon.I have followed the command/syntax instructions that SQLGURU here gave to another user trying to do the same thing:BACKUP DATABASE Pubs TO DISK = '\\zonax\c_share\pubs.bak' WITH INITit comes back with the following error message:"Cannot open backup device '\\zonax\c_share\pubs.bak'. Device error or device off-line. Check SQL Error Log. Backup DATABASE is terminating abnormally.Checking the SQL error log basically reiterates this but is saysSPID60::BackupDiskFile:Backup device \\zonax\c_share\pubs.bak' failed.I checked the security on the network share on zonax and it is set for everyone to write to it.Any ideas why this thing is blowing up in my face?"Edited by - robvolk on 07/22/2002 08:20:34 |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-07-22 : 14:23:27
|
| Is your SQL Server Service running under a Domain account? Try running this command in QA. exec xp_cmdshell 'dir \\zonax\c_share\'. If you get an error, then the account that's executing the command doesn't have rights to the share. If the share has full control for everyone, this would most likely be caused by starting the SQL Server Service under a local system account.Jeff BanschbachConsultant, MCDBAEdited by - efelito on 07/22/2002 14:23:41 |
 |
|
|
|
|
|
Backup problem