To thoroughly test the storage for I\O patterns use SQLIO not sqliosim

ok, so what checks are in place to validate files that have been or not been restored.

If you're doing this completely manual then it is very easy to get out...

aaa-322853 (9/20/2012)

---

Hi,

We have implemented custom log shipping between the primary and secondary database. The secondary database in on a SQL Server 2005 cluster with the data/log/undo files all on...

yes extremely, why do you think i wrote the article 😉

it's the check to make sure the sql server instance is online and responding

Are you talking native backups or 3rd party (Litespeed, Sqlbackup, etc)?

Nater (9/19/2012)

---

Whats...

phani112 (9/19/2012)

---

Hi

We also have a similar situation in my current project where we are planning to have SQL MSCS on ESX. The main purpose of MSCS is for hardware failures...

How do you know? Unless you force reindex you could end up reorging some indexes and this will bloat...

switching to bulk logged will minimally log for an index creation same as simple and won't break the log chain, if its a reorg its fully logged regardless 😉

So, are...

Have you checked Books Online??

Before just going and enabling compression check the pre reqs and restrictions as there is an overhead and sometimes a performance impact.

There's little point moving the masters log file. Best to always keep the master files in one location as with model and msdb too

Hey thanks Grant, i appreciate the vote of confidence

With AlwaysOn features it literally consolidates the functionality of mirroring and failover clustering into one neat...

SQLSACT (9/18/2012)

---

Grant Fritchey (9/18/2012)

---

Yes. If you're trying to set up availability groups, you are dealing with different servers with different storage. Now, that storage could be the same SAN, but...

Satish-1028188 (9/18/2012)

---

Thanks Perry, your suggestions make sense, I would see now, How I can impliment this in my case.

Thanks Sudhakar, yes (in last few cases) it was in-between t-log...

Service dependencies...