Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Mirroring a cluster to a non-cluster

Author  Topic 

MuadDBA

628 Posts

Posted - 2004-11-04 : 14:38:16
I have SQL Server on a cluster, conencted to a SAN at my HQ building. They want to mirror it the Chicago HQ.

The kicker is, they want to use a single server in Chicago, not a cluster. I beleive they are looking at SAN replication of some sort which will leave the files open for modification, etc. However, I don't know how SQL Server would react to that sort of thing. Would it care? Has anyone else done this?

I know, it sounds a little foolish, but is this possible?

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-11-04 : 14:48:15
Maybe log shipping would be the way to handle this?

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

MuadDBA

628 Posts

Posted - 2004-11-04 : 15:10:26
They don't want to do that....they want to do a block-level copy from one SAN to another.
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-11-04 : 15:19:30
I'm not sure how SQL Server would react to such a thing. What about stuff that has not been written to disk yet??

Methinks you'd need to talk to your SAN vendor and see how their SAN replication deals with SQL server.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page
   

- Advertisement -