ADSM-L

Re: Restore SQL 2.2.1 Database To Another Server Automatically

2002-12-16 10:50:29
Subject: Re: Restore SQL 2.2.1 Database To Another Server Automatically
From: Mark Stapleton <stapleto AT BERBEE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 16 Dec 2002 09:33:30 -0600
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 (stapleton AT berbee DOT com)

<Prev in Thread] Current Thread [Next in Thread>