Excellent!

It may be an idea to run checkDB a little more frequently. Weekly, if you can afford the time, otherwise do some databases one weekend,...

Depends what you mean by a DBA. If you're taking about someone that watches jobs, runs backups and deploys changes only, then maybe their job will disappear. There's a lot...

rajeevtenneti (12/2/2008)

---

Unfortunately it was decided to move on to MSSQL backups and we tested on

a development dtabase a db of 40Gb with 38GB data takes 37GB on...

Don't use the database migration wizard. That's a really long way.

Take a backup of the SQL 2000 database and restore it on 2005. Once you're restored, rebuild all indexes and...

Can you backup top the local disk and then copy the backup to take.

Please post SQL 2000-related questions in the SQL 2000 forums. If you...

What about the other index, on OUTP_54?

Ok...

I think that this whole mess can be fixed by dropping and recreating two indexes. I'm not going to promise it will, I'm a bit unsure of the meaning of...

It's a built-in function that returns a resultset of the records currently in the transaction log.

hemanth.damecharla (12/2/2008)

---

Not...

The SQL 2005 parser is a lot stricter about what it considers valid SQL. Technically, that syntax isn't valid, but the 2000 parser would accept it, even though it could...

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...