Moving to a new server

We're moving the QA enviornment to a new server and I want to restore the
database backups (including all jobs).
I know I have to restore the application DB's + model. I think I should be
restoring msdb, but I'm unsure about master.
What other "gotchas" are waiting?
Thanks,
JayYou may or may not need to restore the system dbs depending on what you want
to accomplish. If there is nothing in MSDB that you want to keep other than
the jobs I would just script them and run the scripts on the new server.
Have a look at these:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408.aspx Moving system dbs
2005
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's 2000
http://support.microsoft.com/?id=314546 Moving DB's between Servers
http://support.microsoft.com/?id=224071 Moving SQL Server Databases to a
New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp
Moving Users
http://support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users
http://support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers
http://support.microsoft.com/?id=307775 Disaster Recovery Articles for
SQL Server
http://support.microsoft.com/?id=320125 Moving a Diagram
http://support.microsoft.com/?id=274463 Copy DB Wizard issues 2000
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Jay" <nospan@.nospam.org> wrote in message
news:uDQ03YzGIHA.4592@.TK2MSFTNGP02.phx.gbl...
> We're moving the QA enviornment to a new server and I want to restore the
> database backups (including all jobs).
> I know I have to restore the application DB's + model. I think I should be
> restoring msdb, but I'm unsure about master.
> What other "gotchas" are waiting?
> Thanks,
> Jay
>