Using the object creation scripts you gathered, wrote or reverse-engineered in Chapter 2, “Documenting Your Environment,” build a test environment matching your production system.
Use backups or the bcp scripts to populate your test databases.
When you create a new database and then load bcp files,
you reduce the fragmentation that may be present in the production
system and change the performance characteristics of the database.
If you do not intend to rebuild your production environment, you
may prefer to create your databases as described in “Create your databases by loading backups”.
Run dbcc commands in the test databases immediately after creating them to be sure there are no problems.
