Tools to manage sql 2008 database mirroring?
- by lemkepf
We are going to be moving about 20 databases that live on a single instance of sql 2000 to a sql 2008 r2 environment with database mirroring.
What I'm looking for is a tool or scripts that will help me manage the conversion and management of those 20db's onto this new mirrored environment easily. There are many steps in setting each DB up and I want to automate as much as possible.
Edit:
Here are the steps I've been doing manually:
Create the same username/passwords from the old sql
2000 server onto new sql 2008
server. Then sync those
users/passwords onto the other sql
2008 server with the same SSID's
so when we do the db backup and
restore they match up.
Take a backup of each sql 2000 db's.
Copy them to server A.
Restore the backup to server A.
Backup from server a, copy to server b, restore there.
Run the mirror "configure security" wizard.
Start mirroring.
I've love to be able to script this out or have a tool that does it for me.
Thanks!
Paul