What every DBA should know.
Here are some sample T-SQL scripts for backing up and restoring databases and transaction logs (using AdventureWorks on the C: drive, which would not be a good idea in reality). They also show how to detach and attach a database, and how to do some basic index and statistics maintenance. This was originally for the MCIS-4423 class that I teach at Denver University.
No comments:
Post a Comment