"Cannot open backup device 'C:\backupname.bak'. Operating system error 5(error not found).BACKUP DATABASE is terminating abnormally." and the only location i can create the backup is "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup".
Cause: becaue the SQL Server Express Service run under account "Local Syetm Network".
Resolution:
1. Go to "My Computer" ==> "Control Panel" ==> "Administrative Tools".
2. Open "Services".
3. Locate Service with name "SQL Server (SQLEXPRESS)" and Open it.
4. Choose "Log On" tab.
5. then select "Local System Account".
6. Press "OK".
7. Right Click on the service.
8. Choose Restart.
Created ByAhmed Abdel Moneim
No comments:
Post a Comment