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 2008 Forums
 SQL Server Administration (2008)
 Backup job problem

Author  Topic 

thermalfake
Starting Member

2 Posts

Posted - 2013-01-22 : 06:48:41
Hello,

I am using SQL Server 2008 R2 (RTM) Express Edition with Advanced Services (64-bit) RTM (10.50.1600.1)
There is an Uranium Backup 8.7 Pro application which create backups every day. All the time I get email about error which says

Cannot open backup device 'E:\BAC\filename.bak'. Operating system error 2

Of course this file not exist on disk.
I've checked Studio manager on database and when want to change path (file exist) everything is ok until i open properties again - remember old path. The script for job is

BACKUP DATABASE [Company] TO DISK = N'E:\BAC\filename.bak' WITH NOFORMAT, NOINIT, NAME = N'Company-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

Could you tell me how to resolve problem ?

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2013-01-22 : 12:18:05
Do you have access on E:\BAC folder?
Go to Top of Page

thermalfake
Starting Member

2 Posts

Posted - 2013-01-23 : 17:08:35
Yes I do. All admin rights.c
Really frustrating in Studio Management where I clik on database and then Tasks -> Backups, change destination file path, save and it revert when open again properties.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2013-01-23 : 21:51:44
Does SQL Server Account has permission to E:\BAC\filename.bak?
Go to Top of Page
   

- Advertisement -