Mirroring

Question

Hello,

I have Microsoft SQL SERVER 2005 installed in my system.

 

To try out mirroring, I rightclicked on the database went to the tasks, but i found that in Status its written

"This database has not been configured for mirroring"


What shall I do now?

Answer 1

I think there are 2 possibilities,

 

1. You have Sql server RTM.......Microsoft supports mirroring from Sql 2005 SP1.......with RTM also you can configure mirroring but prior to that you need to start sql server with Trace flag -T1400 and then proceed with mirroring.

2. You need to take full backup and one transactional log backup  in principal server and restore it in mirror server using the option WITH NORECOVERY for both the full backup and tran log backup.............then start configuring mirroring it will work perfectly...........

 

refer these links for mirroring,

http://sql-articles.com/articles.php?pageNum_alltop=3&totalRows_alltop=35

 

http://sql-articles.com/articles/dbmrr.htm

 

Revert if you need any more help............

Thanxx

Deepak

Answer 2

 

downloading sp1.

Will certainly revert if any problem arises.

Thank you

Answer 3

 

Which SQL edition you installed?  Only Standard and Enterprise supports Database Mirroring (SQL Server 2005 Features Comparison - http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx).

Answer 4

You can download the latest service pack SP2 for SQL 2005 from

http://technet.microsoft.com/en-us/sqlserver/bb331754.aspx instead of SP1..........