How to Transfr SQL Database to an Other Server

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jannie-186227 SSCrazy Points: 2319 More actions · Answer 1

Hi Krishna

Someone won't be able to write a query for you as your system is most likely unique.

But what you can do is goto query analyzer, type backup, highlight it and press shift + 1.

This will give you an example how to do it.

The GUI also have a large amount of templates.

You can acces this by going to query analyzer, view -> template explorer,

there are also templates for backups.

Cheers

Jannie

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 2

As always it depends.

IMO best is to create a full database backup and restore that to your new sqlinstance.

You'll need to migrate the users yourself (sqlusers / windows groups or logins)

There are helper tools for that.

As always, doing this in a rush may cause issues because of the rush conditions.

I've added a little generator script that will help you restore your db on the new instance;

It needs to be executed with an active connection to the new instance using SSMS (results to text)

Write out your scenario and tick the steps you performed.

What is your scenario ?

What's going to happen with the current db ?

How about backup regimes on the new instance ?

..

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this