Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

moving sql server to a new server

Posted on 2012-04-09
6
291 Views
Last Modified: 2012-05-07
Hi,
we are planning to get  a new server to replace our current sql server running on windows 2003 standard. Since we will probably be running windows 2008 or 2011 on the new server, what is the best way to move sql data to this new server?  I thought of taking backups within sql management studio on current server and then restoring to new server but dont know if there are any gotchas i should be aware of if any in performing this process.  We are currently running sql server 2008 on the existing sql server and it is not a domain controller.
0
Comment
Question by:dankyle67
  • 3
  • 2
6 Comments
 
LVL 59

Accepted Solution

by:
Darius Ghassem earned 400 total points
ID: 37824712
Here are you options.

http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx

With a move from Sql 2008 to Sql 2008 it is pretty painless
0
 

Author Comment

by:dankyle67
ID: 37824728
So if we stick to 2008 sql server on the new server as well then the move from existing 2008 server to new server should not be that difficult?
0
 
LVL 59

Expert Comment

by:Darius Ghassem
ID: 37824739
Right. Even if you go to SQL 2008 R2 it shouldn't be that difficult.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:dankyle67
ID: 37824770
looks like the copy process within sql management studio is the way to go since it also preserves the logins.
0
 
LVL 59

Expert Comment

by:Darius Ghassem
ID: 37824794
Yes sir
0
 
LVL 5

Assisted Solution

by:kollenh
kollenh earned 100 total points
ID: 37825190
Just as a reassurance, I've moved databases from SQL 2005 to 2008 and back without any drama.  The logins are the only issues I've had to address.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question