Using Detach and Attach to Transfer Your Data
If you want to make sure that you know what data has been transferred and you are able to take your database offline for a period of time, using Detach and Attach to transfer data might be the right option for you. The major disadvantage of using the Detach/Attach method is that you have to make your database unavailable for a short period of time while it is detached. You need to make a copy of the .mdf file (mdf stands for master database file) and that can only be done while the database is detached. This means that your database will be unavailable as long as it takes you to make a copy of the database. If you have a large database, you may not be able to make the copy in a reasonable amount ...
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
