Again it depends on how critical the data is and you need to justify taking differential backup.

In your environment taking differential backup will only help when you need to recover...

Run the "Alter Index" command "with SORT_IN_TEMPDB = ON"

HTH

Ganga,

I agreed with Mohammed Sort in tempdb option will use space of tempdb your tempdb will grow 🙂 to restrict the logfile growth during maintenance.

set Tlog to perform every 10...

Mine is wrong too! mdf 3 MB + LDF 1 MB = 4 MB for SQL 2005 EE.

Question should be more accurate but anyway I enjoy all this discussion 😛

Cheers!

First of all check if the Database Mail is enabled in surface area configuration.

Second, check SMTP Server is configured correctly and prot 25 is open as default it's communicating to...

Looks like your database is not of production as you are trying to delete the database; if so you can put the database into single user mode with no wait...

I doubt if it's possible for result pan 🙁

check this out I have picked from the yesterday thready:

http://sqlblog.com/blogs/aaron_bertrand/archive/2008/05/06/when-was-my-database-table-last-accessed.aspx

is it possible to post the result of sys.dm_db_physical_index(null,null,null,null,null) so that we can have closuer look.

I also go wrong...

I also think that there are only two instances. But actually it’s Total 3 instance including default.

If we think logically nothing should be affected. But I still...

Log file size of 4 MB is very normal compare to total db size 133 GB. Even if log file size is 4 GB due to typo mistake It is...

What is the size of the Database?

What is the size of Data and Log files?

Size of the Tlog depends on the nature of the application and what activities are running...

I beg your pardon. It's not UPDATE STATISTICS it's DBCC UPDATEUSAGE. Run UPDATEUSAGE before SHRINKDATABASE OR SHIRNKFILE.

"DBCC UPDATEUSAGE corrects the rows, used pages, reserved pages, leaf pages and data page...

Can you check if UPDATE STATISTICS help?

Just guessing...

Also it's depends on the size of the Database too. If the database is too large than re-orgeanize will be helpful so that there will not be any blocking etc....