failed to backup - SQL Server Forums

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)

failed to backup

Author

Topic

gongxia649
So Suave

344 Posts

Posted - 2007-04-30 : 09:05:32

i restored a DB 3 weeks ago. Since then started to failed only every friday when performaing backup. i looked at the msserver log. but doesnt tell me anything.

msserver log
2007-04-27 21:25:01.48 spid184 BackupVirtualDeviceSet::Initialize: Open failure on backup device 'prodplan_00__ca5c83a8_9590_4d12_bd36_46a03ea60d3a_'. Operating system error 0x80070002(The system cannot find the file specified.).
2007-04-27 21:25:01.48 backup BACKUP failed to complete the command BACKUP DATABASE [prodplan] TO virtual_device = 'prodplan_00__ca5c83a8_9590_4d12_bd36_46a03ea60d3a_'

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-30 : 13:13:54

Where does the device point?

gongxia649
So Suave

344 Posts

Posted - 2007-04-30 : 15:06:40

BACKUP DATABASE [prodplan] TO [prodplan_BackupDevice] WITH INIT , NOUNLOAD , NAME = 'klxprodplan backup', NOSKIP , STATS = 10, NOFORMAT

it points to R:\Backup\prodplan_BackupDevice.bak

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-30 : 15:08:34

And your "R" drive is a network-attached path?

Peter Larsson
Helsingborg, Sweden

gongxia649
So Suave

344 Posts

Posted - 2007-04-30 : 16:22:47

not sure. how can i find that out?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-30 : 16:24:19

If it's remote drive, you have to start sql agent service with domain account that has permission to create file on the drive.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-30 : 16:24:40

In Windows Explorer.
Check Tools -> Disconnnect. If R: is present there, R: is a network drive.

Peter Larsson
Helsingborg, Sweden

gongxia649
So Suave

344 Posts

Posted - 2007-04-30 : 17:05:11

peso,
its not a network drive. there is not network drive.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-01 : 10:29:37

Did you see R:\Backup\prodplan_BackupDevice.bak in windows explorer? Does sql agent service account have permission on R:\Backup?

gongxia649
So Suave

344 Posts

Posted - 2007-05-01 : 13:11:12

Did you see R:\Backup\prodplan_BackupDevice.bak in windows explorer?
yes

Does sql agent service account have permission on R:\Backup?
yes it does...cause it backs up every day but it doesnt work only on fridays since my last restore.

BACKUP failed to complete the command BACKUP DATABASE [prodplan] TO virtual_device = 'prodplan_00__ca5c83a8_9590_4d12_bd36_46a03ea60d3a_'

BackupVirtualDeviceSet::Initialize: Open failure on backup device 'prodplan_00__ca5c83a8_9590_4d12_bd36_46a03ea60d3a_'. Operating system error 0x80070002(The system cannot find the file specified.).

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources