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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-12-02 : 08:14:51
|
| Jeff writes "Overview ----------------------- We have multiple SQL Server 2000 Servers in production. Each SQL Server has 50 - 100 SQL Databases. Databases are added and deleted on a regular basis via a web Control Panel. Currently we are using the 'Database Maintenance Plan Wizard' to run daily backups of all databases including master and backing them up to a remote server. Each database backup is a .bak file.Problem ----------------------- In the event of a disaster, we need to quickly be able to restore all databases and database users to a new server or same server with a fresh OS Install. Can you please help?" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-12-02 : 09:46:14
|
quote:
Originally posted by AskSQLTeam
Jeff writes Databases are added and deleted on a regular basis via a web Control Panel.
Should have thought of disaster recovery before you implemented this methodology. Why do you do that? I would think you would need a more sofisticated backup and recovery model than the wizard would give you.Brett8-) |
 |
|
|
|
|
|
SQL Server Disaster Recovery