Answered by:
Mirroring

Question
-
Hello,
I have Microsoft SQL SERVER 2005 installed in my system.
"This database has not been configured for mirroring"
What shall I do now?Wednesday, August 22, 2007 2:53 PM
Answers
-
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
Wednesday, August 22, 2007 3:12 PM
All replies
-
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
Wednesday, August 22, 2007 3:12 PM -
downloading sp1.
Will certainly revert if any problem arises.
Thank you
Thursday, August 23, 2007 5:57 AM -
Thursday, August 23, 2007 6:03 PM
-
You can download the latest service pack SP2 for SQL 2005 from
http://technet.microsoft.com/en-us/sqlserver/bb331754.aspx instead of SP1..........
Friday, August 24, 2007 3:37 AM