The question is correct.

I got it wrong because I always refer to it as mssqlsystemresource and thought 'resource' was incorrect shorthand, but turns out microsoft refer to it as the...

both a full backup and a log backup will issue a checkpoint and put a marker in the log at the end of the backup process, this is the point...

how about add the NT roles to db_datareader in model database then this set up will be in every db created in the instance....

Both from microsoft -

theres sqlio which will tell you the maximum io throughput you can expect

and

sqliosim -which will simulate generic Sql activity and give you an idea of io...

8.00.194 is the base RTM version. Apply SP4 and see how u get on.

Marios,

if it helps, the following actions flush the proccache:

http://blogs.msdn.com/sqlprogrammability/archive/2007/01/17/10-0-plan-cache-flush.aspx

hopefully MS will work on only flushing the cache of objects for the database the action is upon. If you think they...

Grant,

hate recompiles? see this:

http://blogs.msdn.com/sqlprogrammability/archive/2007/01/17/10-0-plan-cache-flush.aspx

and this:

http://www.sqlservercentral.com/Forums/Topic494663-149-1.aspx#bm494664

it can be caused by parallelism, waittype will generally be 'cxpacket', and there will be multi connections with the same spid.

Can also be caused by i/o, waittype will be various...

just watched my proccache on a 2000 box before\after a log restore and did not see this behaviour..............

thanks Jack, I like the idea of taking chunks out of this table a day at a time.

I'll post results which will be next week now, way too much...

very good catch, could...

database read only -

add an if statement in the cursor loop to only execute code if database not read only, i.e.

if (SELECT DATABASEPROPERTY(@dbname, 'Isreadonly')) = 0

begin

...

If your .mdf and .ldf are large but contain a small amount of data so the .bak file is much smaller, it could take longer to do detach\attach than backup...

then I am afraid I am not sure, any other log shipping table list anything reflecting an error or the status of the job runs.

If sql agent jobs are not failing don't quite see where error is. The 'message' column in the table will tell you what the error is if there is one.