You can get the counters to look for from the link given below

http://www.sql-server-performance.com/tips/sql_server_performance_monitor_coutners_p1.aspx

select a.name,(sum(b.size)*8)/1024,SUSER_NAME(a.owner_sid)

from master..sysaltfiles b, master.sys.databases a

where A.database_id=B.dbid

group by a.name,a.owner_sid

order by 1

OK you mean to say there is a server which runs on local adminstrator account and yes exactly these cause the problem. you need to cahnge them to run in...

You add them to the security admin group in the database. That should be fine.

Did you ucheck if that schema owned any user types.

THis is a HOP problem. You need to run your sql services in a domain account to access the network resources. Else this will fail as the local system account...

Removing BUILTIN\ADMINISTRATORS and adding a service account is the recommended config in SQL Server. So you are on the right way.

No don't create it in the model database as this acts as a template for user DBs to be created and your procedure will be created in all your new...

THis is a HOP problem. You need to run your sql services in a domain account to access the network resources. Else this will fail as the local system account...

Or you can check the properties of the user and then add the database access to it.

John I should have bolded this syntax so that to avoid confusion. I was meaning the same that you both were saying

You can do a clustering in this case. Also you can think about doubletake replication which suits your req.

Yes i was meaning to restore the PROD copy. You have no backup of the test DBA and how would you restore to the previous point there is no way.

To add more to this when you set autogrowth to 10% it means that whenever the database is in need of space it grows 10% the size of now. suppose...

In this case you can go for a replication add only those objects to be moved to the DR server as articles in the replication and leaving others so that...