Thursday, December 19, 2013

Restore failed Operating system returned the error 5 (Access denied)

I was trying to restore a database using SQL 2012 management studio but when I click ok after selecting file I was getting below error

clip_image002

Cause:

By default the database and log files are creating in MSSQL10_50.MSSQLServer folder.

image

Resolution:

Check the Relocation all files to folder  in the above fig. so that it will create files in MSSQL.11.NAVDEMO folder

Share:

0 comments: