I have two separate SQL Clusters which I need to automate restoring
one database from Cluster A to Cluster B. The database on Cluster A
has a daily full backup.

How can the restore process be automated between the two clusters?

The easiest way is to script the process.

Alternatively, you could use log shipping if you are in FULL Recovery and do
log backups on the targeted databases. This has the advantage of using a
built-in feature of SQL Server.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Robin9876" <robin9876 (AT) hotmail (DOT) com> wrote

Hi
Does it work for you?


RESTORE DATABASE foo
FROM DISK = '\\Primary\D$\dmp_foo.BAK'
WITH FILE = 1, NOUNLOAD , STANDBY = 'E:\mssql7\logs\undo.ldf', STATS =10,
REPLACE ,
MOVE N'foo_Data' TO N'F:\MSSQL\data\foo.MDF',
MOVE N'foo_Log' TO N'E:\mssql\logs\foo.ldf'
go



"Robin9876" <robin9876 (AT) hotmail (DOT) com> wrote

I was not sure if SAN drives could be shared across instances but it
appears to be.

The only issue would be how to identify the bak file, as the file name
changes daily due to containing date time in the name. As an
alternative I could create another backup before the restore to create
a file to a known name but would prefer to use the current backup
process.

On 3 Sep, 06:17, "Uri Dimant" <u... (AT) iscar (DOT) co.il> wrote:

Well, if you backup hte databases, you surely know, or alt least can figure
out, what files you are backing them to, right? The file names may have
datetime strings, but still you should know. If not, what's the point of
doing the backup?

Linchi

"Robin9876" wrote: