David Benoit (12/3/2010)

---

YSLGuru (12/3/2010)

---

D:\MSSQL\Install\osql -E -n-1 -i D:\MSSQL\Install\instmsdb.sql -o C:\MyExecution.txt

I am not an OSQL guru so I may have misused it. Is osql.exe an executable that is picky about...

I actually got past that error and now am having trouble executing the sql file 'instmsdb.sq'....

GilaMonster (11/24/2010)

---

YSLGuru (11/24/2010)

---

I have to make a decision about what to do by tomorrow and since its the Holidays I didn’t; know if you would be reading the threads again...

Jeffrey Williams-493691 (11/30/2010)

---

GSquared (11/30/2010)

---

Batch files from a scheduler is how I'd go about it, except I can't think of any reason I'd ever want to reboot a server on a...

Gail - Hopefully your still watching this thread. I debated creating a new thread about this (what I discovered today that may be game changer on this investigation) but...

GilaMonster (11/23/2010)

---

As I mentioned earlier, any corruption is an indication of problems in the IO subsystem.

Corrupt pages don't usually appear and disappear, unless the pages are getting deallocated (index rebuilds,...

GilaMonster (11/23/2010)

---

Odd. The checkDB shows 3 pages with errors, all in the clustered index.

Could something have deleted rows from that table (and resulted in pages deallocated) before the backup that...

Gail,

Of course I'm not just looking for commiserations. Because of an NDA with the vendor (the software app that uses this DB) I have to check with legal anytime...

GilaMonster (11/22/2010)

---

Run a checkDB, see the output.

Checksum error is a damaged page, it's a page that has been modified by something since SQL wrote it out to the filesystem. The...

GilaMonster (11/22/2010)

---

Run a checkDB, see the output.

Checksum error is a damaged page, it's a page that has been modified by something since SQL wrote it out to the filesystem. The...

Gail, Thru some testing, while waiting for a restore of the DB I can DBCC against (takes 3 hours plus or minus an hour to restore the DB )...

GilaMonster (11/22/2010)

---

Nope.

http://www.sqlskills.com/blogs/paul/post/CHECKDB-From-Every-Angle-How-long-will-CHECKDB-take-to-run.aspx

If you don't know what the problems are, do a full checkDB. Two reasons

1) If you post here asking for help, it's the first thing I'll ask you...

David.Poole (11/11/2010)

---

This is on my list of "stupid things no-one in their right mind would try" and I apologize to any DBA for revealing how you do this.

EXEC sp_....

People use...

PaulB-TheOneAndOnly (11/8/2010)

---

YSLGuru (11/8/2010)

---

PaulB-TheOneAndOnly (11/8/2010)

---

Always remember Rule #4 which states "DBA are responsible for...

PaulB-TheOneAndOnly (11/8/2010)

---

Always remember Rule #4 which states "DBA are responsible for database recoverability"...