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

I need to Migrate SQL Server

I need to come up with the best solution to migrate SQL Server data from one service to another.  What would be my best approach
0
Idarac
Asked:
Idarac
2 Solutions
 
Dirk MareSystems Engineer (Acting IT Manager)Commented:
Backup and restore the database.

Are you moving from the same SQL version to another or from older to newer or newer to older?

DirkMare
0
 
Lieven EmbrechtsSenior IT ConsultantCommented:
in sql server enterprise manager, you can select the database, then in the tools menu you can backup the database.
in the new environment you can create the same login and restore the database.
then you have to let your clients connect to the new server. that's all.
0
 
IdaracAuthor Commented:
Thanx to both of you.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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