O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

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

Tips and Techniques

All great administrators know a few tricks to help manage databases more efficiently and to keep things running smoothly. Here are a few tips to help you with database administration.

Copying and Moving Databases

All databases except model, msdb, and master can be copied or moved using the Copy Database Wizard. You can also use this wizard to create a copy of a database, to copy or move databases between different instances of Microsoft SQL Server, and to upgrade databases from SQL Server 2000 to SQL Server 2005. The Copy Database Wizard uses one of two techniques for copy and move operations:

  • Detach and Attach. This method is the fastest way to copy a database, but it requires the source database to be offline so it can be detached ...

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