September 9, 2009 at 9:04 am
What is the fastest way to move two dozen DB's from one server to another server?
September 9, 2009 at 9:07 am
krypto69 (9/9/2009)
What is the fastest way to move two dozen DB's from one server to another server?
Depends on the size! If they are big, a backup/restore with something like LiteSpeed will be good.
If they are small and you can stop the services on the primary server, then copy them over the network and attach.
Don't forget to move the logins as well!
September 9, 2009 at 9:09 am
krypto69 (9/9/2009)
What is the fastest way to move two dozen DB's from one server to another server?
well as long as you have latest backups for them. simpliest answer, is to deattach the databases, copy them over to the other server and then reattach them on the other server.
Bear in mind that, you will be taking them offline so you cannot do this in the working day, if the databases are in constant use. otherwise copy backups over to the other server and restore them.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 9, 2009 at 9:34 am
Yep they are pretty small..and it's okay to take them all off line.
So it would be better to dettach the MDF/LDF's then it would be to create BAK files?
Is there a script out there that I can use to copy all logins?
September 9, 2009 at 9:40 am
krypto69 (9/9/2009)
Yep they are pretty small..and it's okay to take them all off line.So it would be better to dettach the MDF/LDF's then it would be to create BAK files?
Is there a script out there that I can use to copy all logins?
if they are small, there is no real difference. if you search on this site for 'script all logins' you will find numerous scripts.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 9, 2009 at 9:43 am
Cool, thanks everyone.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply