SQl Database

Question

I use a thrid party software and replicated nearly 50 sql database to a DR server. I am able to mount all SQl Database except 1 daatabase. This Specific database shows "Recovering" in Enteprise Manager. I was able to get this database online one time and this took nearly 20 minutes time. The size of this db is less than a GB. This is SQl 2008 Server. Did someone encounter similar issue before please advise.

 

Answer 1

I would suggest you to use db mirroring for DR Servers. Its easy to configure and maintenance.

Please visit this http://www.mssqltips.com/tip.asp?tip=1564

 

---

http://uk.linkedin.com/in/ramjaddu

Answer 2

If you do start thinking about mirroring, you should read this first http://sqlcat.com/technicalnotes/archive/2010/02/10/mirroring-a-large-number-of-databases-in-a-single-sql-server-instance.aspx

---

Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: MrWharty.wordpress.com

Answer 3

What's the size of the transaction log of this database and what is it's recovery model.

If the T-log is very big and the database is in full recovery mode, take a backup of the T-log, shrink it (not to small, give it the necessary space to work), and try to replicate again.

BTW what software are you using?