Hi guys
I am hosting 120 databases on SQL server 2000 standard edition. Currently to backup the databases I stop the SQL Service, backup the MDF and LDF files using backup software, then restart the SQL service. I now need to have 24/7 uptime.
To remove the blackout period used for backups I need to run a backup from inside SQL server, then backup the backup.
Is there a script or something I can use that queries the master DB for the names of the databases, then backs them all up, one at a time in a loop or something like that?
I am hosting 120 databases on SQL server 2000 standard edition. Currently to backup the databases I stop the SQL Service, backup the MDF and LDF files using backup software, then restart the SQL service. I now need to have 24/7 uptime.
To remove the blackout period used for backups I need to run a backup from inside SQL server, then backup the backup.
Is there a script or something I can use that queries the master DB for the names of the databases, then backs them all up, one at a time in a loop or something like that?