Quote Originally Posted by DWRoelands
Sure there is. Schedule a Microsoft Backup job to run overnight and dump the backup files to CDR. Or, have the backup files copied to a folder that's included in your systemwide backups.
And we do that... nightly.... but if it becomes currupted in the middle of the day (which it has done before).... we run the risk of losing the day.. but our SQL server is backup (transactionaly) hourly... so we'd at most lose a couple of hours.

And, as we recently found out, it's a real #%^E*& to move to a different server.

Tg