SQL Server 2005 Restore Database error Resolution _MSSQL

The following error occurred while the source database was also (see figure below for details):

System.Data.SqlClient.SqlError: In the ' C:\Program Files\Microsoft SQL Server\mssql.1\mssql\businessdb.mdf ' Try ' Restorecontainer::validatetargetforcreation ', the operating system returned error ' 5 (Access denied. )'。 (MICROSOFT.SQLSERVER.EXPRESS.SMO)

Reason Analysis:

There is no permission to create a file for "C:\Program Files\Microsoft SQL Server\mssql.1\mssql\" (You can copy it to data), which is a SQL2005 security restriction on the folder.

Solution:

Modify the folder to the ' C:\Program Files\Microsoft SQL Server\mssql.1\mssql\data\ ' or other disk folder (such as E:\mydb). Note: Both the MDF file and the LDF file path are modified.