SQL Server 2008 migration (from 2000)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

SQL Server 2008 migration (from 2000)

Author

Topic

Greenwhite
Starting Member

5 Posts

Posted - 2010-07-08 : 13:30:36

If I leave behind the master and MSDB databases and move only the SQL Server 2000 databases that I need, will I be ok? I know other things can go wrong. I think I'm going to move only the databases I need. But now I'm not sure what the master and MSDB databases did.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-08 : 13:57:42

Typically all that's needed from master and msdb are logins and jobs. But you'll need to review your system to determine if there's anything else you need. Enterprise Manager allows you to script the jobs. You can use SSIS or DTS to transfer the logins, although I use this method: http://www.windowsitpro.com/article/query-analyser/sql-server-login-transfer.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Kristen
Test

22859 Posts

Posted - 2010-07-08 : 18:09:57

In case helpful: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources