Roy Ernest (2/18/2011)

---

Now a days, you do not see that many Draws in test. I am glad. Even though it takes 5 days, I prefer test over the One days...

Brandie Tarvin (2/18/2011)

---

I agree. In fact, I was mentally...

we just tried that, same error there! Oh dear. something server related or we just found a new bug. I'm calling in MS.

its a new database created by an ETL process, database is corrupted as it creates so no chance to back it up!

It obviously can be recreated but new database...

thanks for the confirmation Gail. Have a good day (I'm not!)

there were loads of issues with jobs in early releases of SQL2005, this was likely one of them.

you should patch your SQL instance for this reason and more importantly...

you might want to break that down further to database files so you can see data and log file activity, but anyway DMV sys.dm_io_virtual_file_stats is the one you want, it...

I'd look at the amount of IO per database so try this

--Calculating the Percentage of I/O for Each Database

---------------------------------------------------

WITH Agg_IO_Stats

AS

(

SELECT

DB_NAME(database_id) AS database_name,

...

you are on the RTM version of SQL2005 which is somewhat out of date. SP4 is out now so you should roll that out(after testing first)

Koen Verbeeck (2/16/2011)

---

Jeff Moden (2/16/2011)

---

CirquedeSQLeil (2/16/2011)

---

For the execution of Wayne:

--get spid of code requestor

sp_whorequestedcodeIntheThread 'Wayne'

--use returned spids to verify the request

dbcc inputbuffer(61)

--output

'Wayne definitely requested code on the thread'

--yup...

the situation during extended support seemed to have changed which piqued my curiosity so I asked our MS contact what the rules are. I post his answer below which I...

backup every database to a separate file, don't mix different backups together. In fact don't use backup sets, I can't see any point in them. As you are finding out...

With my memory I am in the unfortunate position of being able to truthfully claim to have forgotten more about SQL than I actually know 🙂

Are you backing up all your databases to the same backup set? If so I would stop doing that.

Looks like the backup file you are selecting is not the master...

As this database has been upgraded from SQL2000 run DBCC CHECKDB with DATA_PURITY if you have not already done so (during next quite period yada yada :-))

After that run checkdb...