Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Elmar
Starting Member
3 Posts |
 Posted - 2004-08-13 : 12:04:03
|
| Hello,I am fairly new to the game and found a lot of help from your Forum.My problem today is, that I need to move approx. 1900 DBs, each has its own user, to a new server.since I did not find anything on Google, I wondered how you would move them? Replication is the best answer I have come up with... apart from manually importing them ;-)Maybe someone had this problem before...Elmar |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2004-08-13 : 12:14:32
|
| Did you mean to move them between sql servers?SQL Server 2000 has a Copy Database Wizard.In Enterprise Manager, from menu Tools, Wizards, Management. |
 |
|
|
Elmar
Starting Member
3 Posts |
Posted - 2004-08-13 : 12:21:04
|
| Hommer,That was quick.I always thought that this would work for a single DB only...Have to test it tonight....Cheers.Elmar |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-13 : 12:24:55
|
| Don't use the copy database wizard. It doesn't grab everything. Use backup/restore or sp_detach_db/sp_attach_db.Replication? To move databases? No. Replication is used to move data not databases.And 1900 databases? Are you sure that's how many you have? When you open up Enterprise Manager, do you see 1900 databases?Is this SQL Server?Tara |
|
|
|
Elmar
Starting Member
3 Posts |
Posted - 2004-08-13 : 17:44:06
|
Hi there,1976 to presise ... It's an online survey DB-Server; each survey has it's own DB...Elmar |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-14 : 12:14:16
|
| That's a stupid design. I would script out detach and attach statements for them. Just copy them over and attach them. After you attach them, you'll need to use sp_help_revlogin to add the users in on the new server. Make sure you do this AFTER you attach the databases or you'll have a mess on your hands. You can search the forum for "sp_help_revlogin" to find the procedure.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
Not sure on how to move 1900 to new server