Hello All,

Is it possible to do these tasks from a database on a clustered server to a
database on a non clustered server?

Backup/restore
Replication
Log shipping
Mirroring

Thank you.

Matthew Wells
matthew.wells (AT) firstbyte (DOT) net

Matthew Wells (matthew.wells (AT) firstbyte (DOT) net) writes:
The first three absolutely. I'm a little uncertain about mirroring, but
I can't really see why not. All clustering is about is that if the machine
goes down, another machines takes over in a minute.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Thanks for your reply. I know that applies to the Windows server, but I
wasn't sure if anything was happening to the mdf/ldf or .bak files that
would make them unusable on a non clustered sql server. I guess I didn't
explain totally.

"Erland Sommarskog" wrote in message
news:Xns9F23E281E83AFYazorman (AT) 127 (DOT) 0.0.1...

Matthew Wells (matthew.wells (AT) firstbyte (DOT) net) writes:
The first three absolutely. I'm a little uncertain about mirroring, but
I can't really see why not. All clustering is about is that if the machine
goes down, another machines takes over in a minute.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Matthew Wells (matthew.wells (AT) firstbyte (DOT) net) writes:
The files don't look different because they are on a cluster. It would
be a major bummer if they did, as you often want to use copies of
production databases in less sophisticated environments.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx