Hello- I need to migrate (or backup and restore) a SQL 2000 sever, including all databases, maintenance plans, etc. I have very little SQL experience. I have read through several different backup/restore documents and most seem to be aimed at the DB level as opposed to all DBs and related configurations. I will have a weekend of scheduled downtime to complete this task. The new SQL server will be new identical hardware and a fresh install of Windows 2003 and SQL 2000. Any advice would be greatly appreciated.
Start Free Trial