You should be able to add cleanup task in the MP and keep your policy "Delete .BAK files older than 2 days"

Thanks Terry and Steve,

First USer has to search it by themselves, if not than only any one can tell them.

Backup plan prepared by DBA with Company(Organization) policy and point in...

Sunil,

You should not be able to lock the DB, but could be able to restict for other users the DB.

Go to the DB property and Click on the Option Tab...

You Should not be able to Delete SA login from the server, But you could be able to DISABLE the SA account from the server.

Use third party toold for Alerting or write code in SQL to send you an alert.

Backup Third party toold if DB's are large in size. On call Support to the...

You need to enable the SQL DB mail option in SQL 2005.

try to write a code for value <1, it will give you all duplicate rows

That's true. it's a windows based and when you delete the DB it will ask you to confirme that r u sure want to delete in Windows and in SQL...

So, Deat friend, All the things to check the MS version. Try one or the other and get the version.

Correct, What do you mean by delete? Do you want to delete the Report of you do want to delete the .rdl file from the reporting services?

I am woundering how...

Probably you have to upgrade the SP's in SQL 2k5., otherwise it would not be in supported by micosoft. Make sure you do have SA permission.

Check the permission you...

SQL Reporting services you installed as part of the SQL server 2k5 installation. You should be shut down the reporting services or else uninstall that from Control Pannel.

Perfact, When you try to use DB in Single user mode or readonly mode It will not allowe you to do that, because some processes still using the DB and...

Well, If you are changing any sort of things related to DB/Server related changed may need to reboot the server or at least restart of the SQL engine/Agent services.

That's true Steve, But try to archive old files which is no loger meaningful for the server/DB. Becuse of this you may cleanup your drive too.