Shulou(Shulou.com)06/01 Report--

Write in the work log

The first error was reported when attaching a database mdf file with sql server 2008, code 5120. Viewing the relevant documents indicates that you do not have enough permissions. Then on the files and log ldf files that need to be attached, right-click Properties-Security, and check the authenticated user permissions to full control permissions. Click apply. Once again, the error is still reported.

Theoretically solve the permission problem, sql server can read and write additional database files failure should be solved. Suddenly come up with a method, and then copy the database files that need to be attached to the database files in the sql server 2008 installer directory. Attach the file again, error code 948.

The reason for viewing the code is that the attachment cannot be downgraded due to the version limitation of sql server. A high-level version of the database file cannot be attached to an earlier version of the database, resulting in an error.

The solution is to reprint Baidu:

You can use scripts to export all the data in the database, and then generate

Just click finish and create an empty database on the lower version of the server.

Finally, the generated database script is executed.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.