You've got database corruption.

Please run the following and post the results.

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

Do you have a backup? Do you have any idea when...

Please post the entire output (or save to a text file and attach it)

There may be stuff that you cut out that you think isn't important, but is.

Hold off...

Active/Active implies that there will be a second SQL instance on the second node that has its own databases. Is that what you're planning?

Clustering isn't a performance enhancement. Active/Active doesn't...

See its contents?

Sure.

SELECT * FROM fn_dblog(null, null)

It's not exactly what I'd call human readable though.

Not overly likely. More likely the shrink picked up corruption that was already there.

When...

What's the max size required by your tran log through the day?

How often are the log backups?

That's RTM. You've got 2005 SP2 on the server and 2005 RTM on the client. I would suggest you run...

Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic611653-338-1.aspx

When you can, run a full checkDB with no_infomsgs, all_errormsgs and see if it gives any errors back.

What build/patch level for 2005?

Do you have page checksums on for that DB?

If...

Agreed. Where in the world are you...

Chris Morris (12/1/2008)

---

Gail, did you notice in your testing if there was significant benefit in using

Where not exists (Select 1

instead of Where not exists (Select *

in Query...

If you click help - about in management studio, it'll show you the version of the client tools. What version do you have for management studio?

What version and service pack?

As part of the create snapshot, you need to specify all data files, not just one of them

So, it'll be something like this

CREATE DATABASE AdventureWorks_snap042007 ON

(NAME = AdventureWorks_Data, FILENAME...

In this case (and I tested out in adventureworks) the exists is better because by using that you're telling SQL that it doesn't actually need to get the rows from...