Backup job problem - 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 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?

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.

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?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources