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 failure

Author  Topic 

JaybeeSQL
Posting Yak Master

112 Posts

Posted - 2012-06-08 : 06:18:13
3041 :
BACKUP failed to complete the command BACKUP LOG [XXXXXXXX] TO DISK = N'\\XXXXXXXX\W$\LOG_BACKUP\XXXXXXXX_tlog_201206072000.TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

This is odd as we have no N: drive on the system, any advice?

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2012-06-08 : 06:41:09
N'..' is just the character datatype (unicode)
The drive is \\XXXXXXXX\W$

Check for space and permission issues - could just be a transient or disk problem.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -