try this

http://akawn.com/blog/2012/01/resolve-log_reuse_wait_desc-is-replication/

have you ever used replication on this database and removed improperly or have you enabled Change Data Capture.

select log_reuse_wait_desc from sys.databases Where database_id =YOURDBID

pass database id and you'll get single row output.

you can make use of compressed backup feature which will reduce your backup size substantially.

also run select log_reuse_wait_desc from sys.databases

and review log_reuse_wait_desc

why you want to take database offline, want to carry out any specific activities.

through SELECT queries your database size will not grow however as i mentioned earlier tempdb might still grow also if you carry out any database maintenance tasks on this database...

Your database should not grow if it is readonly, but if you have complex select queries with lot of sorting, grouping then your tempdb will keep growing.

Table partitioning would be better solution for this, but be aware that Portioning is enterprise only feature.

on which database you are running DBCC command, you can only run this on pricipal server not on mirrored server.

Hi,

an alternative solution would be

Select Service , DATE ,

dense_rank() over(Partition by Service, cast(date as date) order by Date ) srNo

From [TableName]

Hi,

If you got disconnected before your database fully recovers from restoring then it stays in Recovering mode forever, this had happens with me once when i was restoring database over...

i would suggest you to make use of maintenance plans, its not only help you to take different kind of backups also you can control backup retention period through maintenance...

Hi,

in our environment we have excluded mdf,ldf,ndf files from antivirus scanning.

Hi,

passing some default values or altering table to add default constraint would be better solution.

Hi,

do you want to accomplish all three conditions in single query or you need three different queries.