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

Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant 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.