How to Restore File Error 3219 on Microsoft SQL Servers

Written by ts jordan
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Restore File Error 3219 on Microsoft SQL Servers
(Siri Stafford/Digital Vision/Getty Images)

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, utilising the correct command in a process that takes less than 10 minutes in most cases.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Right-click the database to be restored.

  2. 2

    Select the "Restore Database" option.

  3. 3

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

  4. 4

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

  5. 5

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

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.