Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I just started a new dba job and have been given a new server and told to move everything from the old server to the new one, brand new windows and SQL Server installations. I know I have to transfer user databases, logins, SSIS packages and maintenance plans.

  1. Is there anything else I should be aware of to move. Both instances are SQL Server 2008 R2.
  2. Is there an easier way to move the maintenance plans other than scripting each one and applying these to the new server?

Thanks for your help.

share|improve this question

migrated from stackoverflow.com Sep 16 '11 at 20:30

This question came from our site for professional and enthusiast programmers.

3  
Restoring the MSDB database from the old server will help with a lot of the jobs, maintenance plans, etc. –  Joe Stefanelli Sep 16 '11 at 19:04
3  
Is there a time of day/week that these databases and the instance will not need to be accessed? In other words, is there an acceptable period of down-time? –  Thomas Stringer Sep 16 '11 at 23:00
    
@Surfer513, this is a flexible environment. downtime can be scheduled. –  dat_girl Sep 19 '11 at 16:52

1 Answer 1

up vote 3 down vote accepted

This should solve your problem:

http://msdn.microsoft.com/en-us/library/ms345408.aspx

That link has instructions to move system databases from one instance to another, if you move all databases as is (including user ones, for which you can copy the file, however you will need downtime, or if your databases are on a SAN you can use a SAN snapshotting software), the SQL Server will come up with everything intact.. Keep in mind that if you have a named instaces (NAME1\NAME2) then the NAME2 should be same for the destination instance..

share|improve this answer
    
And btw I have tested this approach for many servers, it is much cleaner than scripting and applying.. –  Rohan Sep 18 '11 at 14:58
    
Thanks @rohan. I'll check that article. –  dat_girl Sep 19 '11 at 16:55

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.