Moving SQL

These are the steps to move SQL server/databases by Patrick Wright. It is actually for moving from MSSQL 7.0 to MSSQL 8.0 aka MSSQL 2000, but they are suitable for various moves and it is a good A-B-C pattern for moving.

Related Posts:

• Stored Procedures Code Search
• SQLBPA and order by constant
• T-SQL Paging Series. RowCount
• Check Constraint vs. Rule
• Rendering depends on HTML source formatting
• sp_sproc_columns and Profiler
• SQL Function for Date Sequences (Version 2.1)
• MSSQL: Some Undocumented Features
• Generate Calendar Dates. Version 2.0
• My howto on sqljunkies