Thanks Paul ! Also I saw...

Thanks Paul ! Also I saw...

Hello All,

Just to update the post, I have restored msdb from previous backup and its working fine 🙂

How ?

stop sql agent --> as this will be accessing msdb

restore msdb with...

Hello All,

Just to update the post, I have restored msdb from previous backup and its working fine 🙂

How ?

stop sql agent --> as this will be accessing msdb

restore msdb with...

Paul Randal (3/30/2010)

---

Regardless of what the h/w diagnostics show, you do have a transient corruption problem with your I/O subsystem. That's the only these errors can occur, and to prove...

Paul Randal (3/30/2010)

---

Regardless of what the h/w diagnostics show, you do have a transient corruption problem with your I/O subsystem. That's the only these errors can occur, and to prove...

Paul Randal (3/30/2010)

---

Consistency error on the snapshot file itself doesn't in any way mean the actual database itself has corruptions - but it does mean the I/O subsystem that msdb...

Paul Randal (3/30/2010)

---

Consistency error on the snapshot file itself doesn't in any way mean the actual database itself has corruptions - but it does mean the I/O subsystem that msdb...

GilaMonster (3/30/2010)

---

Interesting... The error is in the snapshot that checkDB creates and uses...

I've referred this to a corruption expert for assistance. It may be necessary to restore from your...

Mistake ! ... double post please disregard this !

Hello,

The script is fine but using MS_foreach is undocumented ! :hehe:

I prefer to use:

SELECT table_name,table_rows FROM (

select so.name as table_name, si.rowcnt as table_rows,ROW_NUMBER() OVER (PARTITION BY SO.NAME ORDER BY si.rowcnt...

Hello,

The script is fine but using MS_foreach is undocumented ! :hehe:

I prefer to use:

SELECT table_name,table_rows FROM (

select so.name as table_name, si.rowcnt as table_rows,ROW_NUMBER() OVER (PARTITION BY SO.NAME ORDER BY si.rowcnt...

dpsahu30 (3/11/2010)

---

Hi,

If there is huge growth in tempdb size then,i suggest rebooting the server wont help much..so i think,we should findout why tempdb is growing so much and important is...

Hello,

I like powershell to do the job. Below is the code that I use: (modify as per your usage)

$file = "F:\temp\Job_logs" ## this will be your backup file...

TheSQLGuru (3/4/2010)

---

Actually you didn't need to read this forum to gain knowledge. That stuff you watched has been on the...