July 25, 2011 at 11:32 pm
Hi All,
Please write the code for database transfer to other server...
Assume Database Name is - DB_Visa on 10.100.25.125 server
Trnsfr to Server - 10.100.25.321
Please do the neeful it's urgent..
Regards,
Krishna
9560305552
July 26, 2011 at 12:26 am
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
July 26, 2011 at 12:47 am
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]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply