Improve Your SQL Server Database Maintenance

摘要

As a developer, you're used to working with database objects. Occasionally, you might even have to put on the database administrator (DBA) hat and work with an entire database. For example, you might backup or restore an entire database. Eventually, you'll probably have to learn more advanced techniques such as attach and detach. By detaching a database, you can remove a database from your server without deleting the files that store the information for the database. Attaching a database reverses the process. In this article, we'll show you how to perform both tasks. We won't cover the backup and restore process, although you might detach and attach database files during the backup process. Rather, this article deals with the processes you'll use to change the location of SQL Server 2000 data and log files.