• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 327
  • Last Modified:

Transfer SQL database to different server

What are the steps to transfer an sql database from one server (SQLServer1) to another (SQQLServer2)? I have MS SQL 2008 on both servers. Are there extra steps if I have MS SQL Server 2012 on MSQLServer2?
1 Solution
Dale BurrellDirectorCommented:
Backup database on server1, restore database on server2. Make sure you don't allow anyone to update the database on server1.

Make sure the correct database users with permissions are setup on server2.

2008 will be happily restored to a 2012 server.
My only addition to dale's excellent comment is for server 2008 ensure both versions are the same or the new server is the later version.
bobox00Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now