On Mon, 2002-12-16 at 04:38, Jeff White wrote: > We have an big SQL 7 Sever at our DR site which justs sits there waiting > for a DR situation, when the data would be restored to it. I was wondering > if it was possible to backup the SQL databases as normal > (full/differential), then restore them automatically (TSM command > schedule?) to the offsite server daily, therefore ensuring that the offsite > server is always up to date.
There's a *much* easier way to do this. Use the utilities within SQL 7 to copy the db files from one SQL 7 server to another, and use the Windows at scheduler to set the time. Much less fuss this way... -- Mark Stapleton ([EMAIL PROTECTED])
