Database Attach and Restore

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

Questions by sreyas kvm   answers by sreyas kvm

Showing Answers 1 - 2 of 2 Answers

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.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions