Did you identify why they are huge? I mean what operations are running against this...

OMGGGG!!!:w00t: That's the scariest thread I have ever seen, I am going to advise the same to rest of my...

Michael,

so If a disaster happens would you restore...

Sudiendra (4/7/2009)

---

Krishna - We have SAN replication enabled. Although i know nothing much about that..all drives are replicated to another server..

Now considering SAN replication, will this strategy work?

BTW, Backup drive...

Sudiendra (4/7/2009)

---

T-Log backup - Every 15 Minutes and Retention Period - 2 Days

Differential Backup - Every day and Retention Period - 1 day (Until the next Diff backup)

Full Backup -...

Welcome, after all its a learning experience but next time just put 1222 on turn off 1204 its a bit misleading

thanks,

Many of the cases I have seen are with the default port either its not enabled or blocked by the firewall. one more counts to my experience.

ben.rosato (4/7/2009)

---

Nope, nothing of the sort.

So, these data...

I am not so sure but my two cents do you experience excessive locking ang blocking on your server?

Yes, Apply Service packs first and if you have any glitches concerning to a particular issue then I advise to look for that particular patch and apply it, but obviously...

sqlsc (4/7/2009)

---

So the reason it can't be defragmented is because it's so small? aka, this problem is basically only an issue because it's a development database? The production tables have...

very small table, so the fragmentation exists you cannot defrag it and its waste of resources.

I really dint get you when yous say backup schedule is at every 12 hrs? Could...

Hiya,

You can schedule a job to change the recovery model to Bulk before the Rebuilding and after it's completion you can change it back to the Full recovery model. You...

Very Very True....It's an excellent source of knowledge and also fun who like to play with the sql server 😀