What is the Difference between Attach and Restore of a Database?

Kiran Patil

 Profile Answers by Kiran Patil Questions by Kiran Patil

• Mar 26th, 2008

Database attach is faster as compaired to Database Restore. SO if you have both options then may be you can choose Database attach than Database Restore.

nbkb9hv

 Profile Answers by nbkb9hv Questions by nbkb9hv

• Feb 13th, 2008

Both are used to restore database, we Use attach database when we have .mdf file to upload data into database while we use restore database when we have .bak file to upload data into database.

Answer Question  Select Best Answer