O'Reilly logo

Microsoft® SQL Server™ 2005: Applied Techniques Step by Step by Solid Quality Learning

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required