Monday, March 26, 2012

Mirror Database in SQL 2000

I am using MS SQL 2000 Standard, is it possible to create a mirror database in SQL 2000? If so, would you suggest how to do this. Thanks! I am a newbie about this.

Unfortunately mirroring is a SQL Server 2005 feature.

You could do log shipping in SQL Server 2000 but that is not exactly the same as mirroring.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

However, I am using SQL Server 2000 Std. which doesn't includes log shipping feature! Besides replication, any other features could do the function of mirroring?

|||

I'm afraid only an upgrade to SQL Server 2005 will give you the full power.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

No comments:

Post a Comment