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 or SQL Server 2005 to SQL Server 2008. 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 ...
Get Microsoft® SQL Server® 2008 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.
