Gazareth (8/19/2014)

---

Are you using SQL Server 2008 or 2008 R2?

Powershell steps on 2008/R2 only run at Powershell 1.0 or 2.0 (and only a subset at that!), Enter-PSSession may not be...

GilaMonster (7/29/2014)

---

I said nothing implying you should have repaired...

See if you can get some automated restore tests set up. Restore backups on another server, run CheckDB. Off the prod server...

GilaMonster (7/29/2014)

---

Start with regularly tested backups and frequent database integrity checks. You should be running integrity checks often enough that it's caught before ending up in the backups. Or, if...

Grant Fritchey (7/29/2014)

---

msandico 57892 (7/29/2014)

---

Grant Fritchey (7/29/2014)

---

1tb isn't quite into the VLDB range, but, once you get past around 3-5tb, you need to start looking at things like SAN snapshots....

Grant Fritchey (7/29/2014)

---

1tb isn't quite into the VLDB range, but, once you get past around 3-5tb, you need to start looking at things like SAN snapshots. But, even that could...

Weekly full, daily diff, hourly tlog backups is our strategy

We tried the diff but since it was data corruption, the diff backups contained the corrupted pages

We using sql 2008...

Thanks everyone for the quick responses, I really appreciate it and almost have resigned myself to say 'too bad' to the app owner..which I really don't want to do..

@gila -...

@SQLFRNDZ (7/15/2014)

---

Recover from the full backups and log backups to the point is the best bet here.

If you don't have the backups then pretty much , you have to...

@gothard - it is a db used by System Centre Service Manager so im sure someone can re-install the app but since it's part of a collection of dbs, I...

andrew gothard (7/15/2014)

---

do you have a team responsibe for your storage, or is it you?

If you have, give them the date and time of the first messages and ask htem...

andrew gothard (7/15/2014)

---

I/O related. If you've had two, then this means there is almost certainly s significant issue with some area of the I/O stack. Have you had...

GilaMonster (7/15/2014)

---

You need to update the column to legal values, consider altering the column later. But there's no guarantee that that is even a legal unicode string. Somehow invalid values...

Digging around some more, wanted to share what I found:

Using this link - http://support.microsoft.com/kb/923247

I did a DBCC PAGE on the affected pages and went to the specific slot...

Hi All,

Just to finish this off, thanks for all the help again.

I figured out that it was a missing clustered index and defragmentation (or fragmentation, whichever way you look at...

Hi All,

Just to finish this off, thanks for all the help again.

I figured out that it was a missing clustered index and defragmentation (or fragmentation, whichever way you look at...