All, thanks for the replies.

The primary aim is to have a DR solution as well as readability/reporting..

Multiple secondary replicas sounds like a plan..

Can someone confirm please..what could be the best...

I finally followed this article and the issue got fixed

http://stackoverflow.com/questions/12542089/how-to-close-a-sql-server-2008-transaction

However, CDC wasnt enabled on my database :hehe:

SQL Guy 1 (3/17/2015)

---

It will work. But is this production? In order to insure that no data will be lost while database in simple recovery model, try to get...

How about changing the recovery model of the database from full to simple, shrink the file and put that back in full recovery model.

Of course, I will take a full...

ZZartin (3/16/2015)

---

Backing up the log does not reduce the file size, so at some point you used 500GB of log space between transaction log backups. If you need to...

Adi Cohn-120898 (1/12/2015)

---

When you rebuild a table, SQL Server modifies the value of column modify_date in sys.objects so it will have the value of the time that the table was...

ok...Would I be able to track these...

GilaMonster (1/12/2015)

---

Benki Chendu (1/12/2015)

---

Just to give you an example, I had a full backup which completed by 1:00 AM and ran a differential backup in sometime which completed by 7:00...

Grant Fritchey (1/12/2015)

---

Then the implication is that you have some process or other that's hitting 400 of the 500gb worth of pages on your database. Is there a nightly load...

Adi Cohn-120898 (1/12/2015)

---

Do you do the index rebuild/reorganize after the full backup? If you do, then this can explain it. Also do you get the 400GB backup on...

GilaMonster (7/24/2014)

---

And that (the bolded part)...

Grant Fritchey (5/14/2014)

---

I'd say show them that error message and let them look it up through Bingle. It's absolutely a hardware related problem and it's very well documented as such...

Grant Fritchey (5/14/2014)

---

It's absolutely an I/O issue. I'd say your disks are being overwhelmed because the issue isn't that a given process is waiting for disk access while another process...

I will try to run the PS command and come back with results.

Nope. Not really. So far, they are new areas