Thank you, My question is under which db I need to create a sp_AddMyTrace and then run it. I need to investigate for all db how data gets deleted. Under...

I ran and there is no errors Thank you

I found the history and this is what I have [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.

why is that?

How you do that? Thank you

Thank you

Also,Integrity job swowing in lSQLogs that ran as DBCC CheckDB,but optimization ran in job history I see and not showing in logs, why is that?

Will any torn pages on, can cause locking when running integrity job?

I can't do that because it will slow down our websides. My maintance plan runs on Sunday. I thought there is a standard command runs for optimization and integrity. Thank...

How, do you know that? I want to know which db changes to 0 status, which to 16 and maybe change options. Thank you

Would something like ‘Torn Pages’ be detected or handled by the optimization job?

Why No reason to shrink a database? what happens web online when this happens?

Do I need to remove for both system and all databases? What happend in future if I remove this option and why do I need to remove it? Thank you

This is what I have for all my db accept system:

EXECUTE master.dbo.xp_sqlmaint N'-PlanID 05C26610-E745-4EF0-9788-D7CCB8A02939 -Rpt "E:\MSSQL\LOG\SAVVIS Full Recovery Model DB Maintenance Plan0.txt" -WriteHistory -RebldIdx 10 -RmUnusedSpace 50 10 '

This...

I didn't find any information about Torn Page Protection, I need to know why my db is set to true in status of sysdatabases and why my other db is...

Thank you, Do I need to set? What is the purpose to set status in sysdatabases? My db2 is to 16 which means torn page detection (ALTER DATABASE). Can you...