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
 General SQL Server Forums
 New to SQL Server Programming
 SQL 2000 to SQL 2005 Server Migration...

Author  Topic 

UltraSPARC
Starting Member

2 Posts

Posted - 2007-04-04 : 15:16:07
OK so I'm just the Network Admin here, but our DBA's are off doing other stuff. So I thought I may inquire here about how the easiest way to migrate from SQL Server 2000 to 2005? The first server I'd like to migrate is just databases with a few users, no DTS packages or anything like that... The only problem is that there are several hundred db's, so moving them one at a time is not an option. Has anyone here had successful experience with doing this? Thanks in advance for your help!
-Andrew

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2007-04-04 : 21:38:50
i'd restore the latest backups to the new server. this can (and should) be scripted.

here http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=83331&highlight_key=y&keyword1=restore is a script that will generate your restore script -- will need slight modification, to the actual location of your backup files and the target destination
Go to Top of Page

UltraSPARC
Starting Member

2 Posts

Posted - 2007-04-04 : 22:02:22
Awesome, thanks! Let me give this a try...
Go to Top of Page
   

- Advertisement -