Try to restore the bakup on the same server with different DB name and pass the correct path for the mdf and ldf file name.

I agree with Terry, but want to make sure that all logshipping should have to run on SA access or SQL_SVC a/c. SQL_SVC a/c should have SA permission but login...

You will get it from msdb DB. "Job History Table"

You will get it from msdb DB. "Job History Table"

What you want to do, Please make it clear.

Probably it has been already posted in other thread. Anyway. Before deleting BuilinAdmin you should be having SQL_SVC a/c and that a/c should have permission as a SYsadmin. but make...

SQL 2005 has report feature and you could be able to find out who has deleted. As above mentioned you can also check it who has SA permission on the...

Agree with colin Leversuch-Roberts, perfactly this is the other option as well.

I would like to say, it's all depend on the organization policy/Cost.

I fully agree with Terry. I would like to add one more thing. If possible try to do the partioning on it. It would also give you some sort of...

If you would know how much data will grow then probably I would recommend you to restrict the autogrowth option. In unrestricted file growth you can not controll anything.

Every application has there DR TEST Plan. Before actually go to DR Application will do the DR Test on the Production and DR.

It will be possible for all the application...

That's the correct answer

I would suggest create on DB DBAUDIT and create some tables and user defined sp's and views and also generate the SQL jobs and configure to send an report to...

Did you setup the autogrowth option or it is in unrestricted?