MSSQL: How to migrate a database server

Derrick Leggett posts a step-by-step guide (aka SQL Server Build Process). This policy even covers scripting out linked servers (among other supporting scripts). Enjoy

Related Posts:

• MSSQL: Partitioning and Parallelism
• MSSQL 2005: Troubleshooting Performance methodology
• T-SQL: Paging with ROW_NUMBER()
• Show MSSQL Query Estimated Execution Plan in XML Format (SET showplan_xml ON)
• T-SQL 2005: One-to-many comma separated
• Oracle: development tool needed
• MSSql 2005: XML indexes and XML queries
• MSSQL 2005: XQuery Implementation in RDBMS
• Primary Key best practices: INT identity vs. UniqueIdentifier (GUID)
• How to change column datatype in Oracle table (ALTER TABLE).