Indexdefrag is also less blocking than dbreindex, but it doesn't do the same phisical thing.

We use Indexdefrag when our productionmill is active (24/7) and we use dbreindex during planed production maintenance...

do you use transactions ?

if yes :

do you commit (data should be there) or rollback (no data will be there) the transaction

Do you...

What if you put it all in a single batch:

ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE

go

DBCC CHECKDB ( 'dbName' ?? REPAIR_ALLOW_DATA_LOSS  | REPAIR_FAST  | REPAIR_REBUILD )

    WITH   ALL_ERRORMSGS

are you the onlyone working on that issue ?

Check your db-status again ! (sp_helpdb)

When putting a db in single-user , I suggest...

I cannot find anything tricky in the query, so I guess it's a data-problem.

It contains only INNER-joins. Are you sure the data always...

check the pros and cons:

Breaking your recovery model can have its consequences !

If I breake it, I go from FULL to BULK, but rarely to simple.

I have some databases of...

aha, ownership-chaining-problems

Who didn't stumble into that.

It may also be e.g. the query is build dynamic or run dynamic

like

create proc owner1.myproc

as

set nocount...

You can also make the backups using SQL-devices.

So from within you sql-backup-job you can see zip , but your backup-device will point to an...

I'll be flying in on 24 sept. 

Brussels - Chicago - Dallas

I hope to be awake by Monday morning

if I'm correct Log P.I. can do such action.

SQLServer itself cannot, unless you do a full restore to point in time.

also keep in mind this user can be databaseowner.

check out sp_changedbowner @loginame = 'sa' ,@map = 'true'

- http://www.sqlservercentral.com/scripts/contributions/1502.asp

- http://www.sqlservercentral.com/scripts/contributions/500.asp

- You just need sqlserver backups to be able to restore. The  backup-history is just a help-set for EM to determine a gui for restore. You can restore on another...