run the shrink first with datapage move then run the reindex. I'm guessing that is what is causing the issues is the DBCC moving datapages to make the shrink happen.

Wes

if the trace is incomplete it could cause this. Usually its due to a trace that isn't setup to caputure the correct data for the ITW.

Wes

Becareful! It was failing due to the fact you were trying to do a transaction log backup on a database set to simple mode. You can always exclude that database...

DECLARE  cur_Databases

CURSOR  FOR

  SELECT CATALOG_NAME

  FROM INFORMATION_SCHEMA.SCHEMATA

  WHERE CATALOG_NAME NOT IN ('master', 'msdb', 'tempdb', 'model', 'pubs', 'Northwind')

DECLARE  @DbName  VARCHAR(50)

DECLARE  @Buildstring VARCHAR(100)

OPEN  cur_Databases

FETCH  NEXT

FROM  cur_Databases

INTO  @DbName

WHILE  @@FETCH_STATUS = 0

 ...

First, I would not move the system databases in a clustered enviornment if I could help it at all. I would generate scripts of users, jobs, operators and permissions detach...

Microsoft provides a free web tool that will let you do what you are talking about. Here is an article that points to some other tools as well: http://sastools.com/b2/post/79394219

Wes

There is a tool from microsoft called DTCping that can help you troubleshoot DTC problems. It will run a transaction and output any messages to a log file. I would...

using temp table is one way select into the temp table that has and ident column on it then use a while loop to loop through it. The best thing...

it means it went to look for a page it thought should have been there and it wasn't there. Since it was in an index you have two choices, try...

Check DNS would be my first thing to say.

--**************************************

--

-- Name: Retrieve rows based on a range

-- Description:How to retrieve rows base

-- d on a range. This solution doesn't use...

Well, SQL should only hold those files long enough to update the statistics then release the database files on a detach. Could there be another process holding the files or...

This is being deadlocked by another process. Like a front end application

You may need to drop the job and recreate it. Also, the job may think it is owned by the old server name and may not allow changes until you...

I use a set of stored procedures written by Narayana Vyas Kondreddi

http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

I then rap those into a stored procedure and call them from a job that rotates them every ...