Migrating SQL Server Databases - The DBA's Checklist (Part 2)

Thursday Sep 24th 2009 by DatabaseJournal.com Staff
Share:

Part 2 of the database migration series examines setting database options, mapping database users to logins, recovery models, backups, and changing the code associated with configurations.

[From SQL Server Performance]

Continuing from Part 1, our Migration Checklist continues:

Step 5: Update statistics

It is always a good idea to update the statistics of the database that you have just installed or migrated. To do this, run the following command against the target database...

The article continues at http://www.sql-server-performance.com/articles/dba/migrating_databases_checklist_part2_p1.aspx

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved