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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 backup failing

Author  Topic 

sqlserverdba
Yak Posting Veteran

53 Posts

Posted - 2009-05-02 : 08:59:22
Hi,

command :
backup database ALLMEDS TO DISK ='\\metro\TESTBACKUP\ALLMTRO.BAK'

Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\metro\TESTBACKUP\ALLMTRO.BAK'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Please advice.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-05-02 : 09:11:11
Looks like the Metro server is offline, or that path is. It would be better to back up to a local device, then copy or move the backup to a UNC path, for obvious reasons.
Go to Top of Page
   

- Advertisement -