App Muncher

Issues faced - solutions identified - shared with community.

Came across an error while taking backup of database in MS SQL Server 2008 R2

Error:
Unable to export database DB_MCMR_63: Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\DB_MCMR_63FullBackUp.bak'. Operating system error5(Access is denied.).

To overcome the error follow one of the following three workarounds:
  • Change the dump folder to a location where the SQL service have sufficient permissions to access it (e.g. a SQLDump subfolder in the SQL install location)
  • Give the Network Service account read/write access to the specified dump folder.
  • Another alternative is to change the SQL service Log On account to Local System or another account with access to the specified dump folder.

No comments:

Post a Comment

| Designed by AppMuncher