no, and it would not make sense to do so. Use update statistics or sp_updatestats in your target database to derive correct and up to date stats foe your database

good to hear. what do you think actually fixed it? orphaned users would simply not have been able to connect rather than cause blocking.

Locking or blocking? The disks have changed so maybe some problem with their configuration? What is the most common wait type, is it IO related?

run perfmon see what response times...

Krishna (9/12/2009)

Rem (9/11/2009)

What is the best method to backup Resource Database? Does someone already has a script for it?

I just realize that this databases is not taken in...

if you bought the secondary online, backed it up then made changes, you broke the lsn chain as soon as you bought it online. To be able to restore logs...

Its not worth moving the system database log files to another drive, theres no performance benefit and you just complicate your install process and put future upgrades at risk. Where...

it won't.

to avoid the problem, when you install SQL, clicked advanced on the features to install screen and enter where you want the database engine data files to be...

no probs.

see Books on line (BOL) alter database statement

SQL just expects those files to be in the same locaton as the master database. as long as they are you will be ok if you set up replication or...

Nothing else is required. you're done

if you mean the distmdl.mdf and .ldf files these are not required till you set up replication.

Just use windows cut and paste, SQL does not lock these files. simples!

check out DDL triggers

......and of course if you have reached the nirvana of all...

replication is not dependant on the recovery mode to function, the publisher can be in simple mode as it will not allow transactions to be removed from the publisher until...