Hello.
I am having problems backing up databases in SQL Express 2008 R2. I get the following error message in SQL Server Management Studio as follows:
Cannot open backup device '\\SAN1\Backup\Test\Test_backup_2012-11-30_01.bak'. Operating system error 5(Access is denied.).
Here's the transact-sql script that I used:
BACKUP DATABASE Test_backup
TO DISK = N'\\SAN1\Backup\Test\Test_backup_ 2012-11-30_01.bak'
WITH NAME = N'Test_backup-Full Database Backup',
CHECKSUM,
CONTINUE_AFTER_ERROR;
I also tried using the backup wizard in SQL Server Management Studio. I get the same problem. The backup fails.
And yet, when I backup different database in SQL Server 2008 Standard to the same folder on the network, the backup works in SSMS or when running a transact-SQL script.
How can I resolve this problem and create backups in SQL Server Express?
Rupertsland, Canada
...
Go to the complete details ...