Did you check what GilaMonster said? Is there an application creating these?

Since your backup is using a virtual device and the databases have IDR in them, I'd guess your...

Running SQL Spotlight. I like that you can define what to get notified on, create custom queries, and also how you can go back in time through the historical...

Lost write is when SQL writes data the OS returns that the write was successful, but it didn't actually get written to the media because of some underlying failure.

A stale...

You might consider trying (based on the last query posted) to remove that exists piece to stop your query from running many sub-queries against your database (it will run a...

Something like this might run better for you if you only have a few columns to match (like the example) and your id cannot be null.

SELECT distinct isnull(a.id, b.id)

FROM A...

This is confusing.. Are you saying you backup file to disk, then tape picks it...

I had to try this, looked very interesting.

It worked for me. The only thing that was a bit different that what you mentioned was the output of DBCC PAGE....

It will act as normal. Backing up your database (Full) doesn't truncate the log. To restore your production, you would grab your latest full backup and TL backups...

DUPLICATE

see http://www.sqlservercentral.com/Forums/Topic715813-146-1.aspx for re-post.

Post your error messages, everything you see.

You can pivot the results. You have to make sure the table names are correct in the query or it will produce null value.

INSERT [dbo].[SIRS_Counts]

SELECT [Col1],[Col2],

[Col3],[Col4],

[Col5],[Col6],

[Col7],[Col8],

[Col9], GETDATE() [RecordDate]

FROM (

SELECT...

If you just want to compare counts, create a Linked Server between them and try this query out (replace server1.database and server2.database):

SELECT object_name(a.object_id), a.object_id, a.[rowcount], b.object_id, b.[rowcount]

FROM (

SELECT p.object_id [object_id],...

Since varchar(max) replaces text data type, does changing the input column type to text work?

Is it installed??

64bit SQL?

http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en

You need to be more clear & proof read before posting.

Are you saying your test box has an SQL 2000 instance installed already and you want to also install an...