首页 > 代码库 > How to Restore File Error 3219 on Microsoft SQL Servers

How to Restore File Error 3219 on Microsoft SQL Servers

File error 3219 occurs on Microsoft SQL servers where you are attempting to improperly restore a database with the "Restore Files and Filegroups" command instead of the Restore Database command. Obviate this error by repeating your backup procedure, utilizing the correct command in a process that takes less than 10 minutes in most cases.

Instructions

    • Right-click the database to be restored.

    • 2

      Select the "Restore Database" option.

    • 3

      Click "From Device" and select "Read backup set information."

    • 4

      Click "Add" and select the backup file you wish to use.

    • 5

      Press "OK" twice to commence the backup, obviating the error 3219 issue.



Read more: http://www.ehow.com/how_6627082_restore-3219-microsoft-sql-servers.html#ixzz32FmdNzr4