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
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.