moving onto a new server!

[dky1e]

Hi,

We just got a new server for the database. What is the best way to move the entire thing (databases, dts packages, jobs, etc...) onto the new server?

Are there any tools available that would help minimize the manual work?

Thanks!

 

[tlbroadbent]

Check out the following.

Moving Databases to a New Server - SQLServerCentral
Note: may require registration with the sites

http://www.sqlservercentral.com/columnists/awarren/20010425205439_1.asp

http://www.databasejournal.com/features/mssql/article.php/1479841

http://support.microsoft.com/default.aspx?scid=kb;us-en;224071

http://support.microsoft.com/default.aspx?scid=kb;us-en;304692

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[MaffewW]

Maybe this should go in an FAQ, seems to come up a lot!

 

[dky1e]

I don't see anything there about dts packages. Does restoring model and master restore the dts packages and jobs?

I haven't had any experience with this process and I want to make sure i do everything correctly.

Thanks.

 

[tlbroadbent]

Packages and Jobs are in the MSDB database. Simply make MSDB part of the process. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.