UAC is causing the error, from http://support.microsoft.com/kb/934164.

1.Configure the report server for local administration. To access the report server and Report Manager locally, follow these steps:

2.Start Windows Internet Explorer.

3.On...

May be the reason tat someone encrypted and he want to...

What type of performance u expect??

If u want point in time recovery(if data is important) u have to use full recovery model..

http://msdn.microsoft.com/en-us/library/ms189275.aspx

this will help u for sure

run select * from sysprocesses and check for the queries..

When u issue a check point uncommitted transaction from buffer cache are written to disk making in commited..

Truncate reclaims the space but wont release to OS for use..

When u issue...

For both 2005 & 2008 the recovey model is Simple??

Thanks Steve and Shiva..

Will DBCC cleantable helps in this situation??

HI Sudeep,

Both Truncate and delte are logged the difference in this sense is truncate is minimally logged ...u can roll back both..

http://rknairblog.blogspot.com/2010/05/can-truncate-rolled-back.html

You can give object level permission to a user..

You can give only select on tables

Remember once to change back to full..dont forget to take a full backup otherwise database will be in simple recovery mode only

Tempdb growth..then its definitely going to be poorly written queries..

As you said you have a capturing mechanism in place ..You should use that and pin point that particular query..

Thanks Everyone...

I feel Steves plan is the best one..

Thanks Gail for pointing that we cannot move file from one file group to another

Do u have any other maintenance plan alreadyu on ur server??

Have u getting any error while opening the BIDS??

AFAIK in log shipping the database will be in restoring state and you wont be able to access the DB

Congrats Phil..All the best

Welcome to SQL Server World..