Locate or create the scripts necessary to recreate:
Server level objects
Database devices
Configurations
Logins and security
Database level objects, including:
Defaults, rules, and user datatypes
User databases
Users, groups, and aliases
Tables, views, and stored procedures
Other database objects such as triggers and indexes
You may also want need to extract and load data with bcp. These scripts can be used to help set up your test environment as well as the building a new production system and may be needed if you plan to maintain two server systems at different release levels.
