Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

scottcabral1979 (Programmer) (OP)
1 Apr 12 9:40
Hi,

we currently have a SQL 2008 R2 database on a Win 2003 32bit box with 4MB RAM and 300GB hardrive.

We just installed SQL Server 2008 R2 on Win 2008 Server with 32MB RAM and 2TB SAN Storage

I have about 10-15 databases that i need to migrate over to the new server. What is the best way to migrate the datbases, logins, SQL Server jobs, etc..? Is there a good side that has step by step instructions or best practices to follow?

thanks
Scott
SQLScholar (Programmer)
2 Apr 12 5:00
I cant find instructions - but i have done a test DR a few times and this is what i do!

Backup\Restore your System databases (master, model, msdb) onto the new server. Look online how to do this.  Type something like "SQL restore Master" into google.  You will need to put the database into single user mode first.  This will move all your Users over (database server wise).

Once restored all system databases (and SQL restarted) you will see all your other databases will be there but be offline. Restore each database onto the new server.  Once restore is complete they should then become operational.  All users will then map back to the database server users that you did in the above bit.

----------------------------------------
www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

SQLScholar (Programmer)
2 Apr 12 5:01
heres how to restore master

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

----------------------------------------
www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close