We use SQL Compare and script out all the changes, and apply after the refreshment. 😀

One question: if you use backup/restore from Production to QA, how do you keep the changes in QA? (I know the data is refreshed, but, what about the others?)

What does the job history say?

Can you use "IS_SRVROLEMEMBER" function? (Check Book Online for the detailed info.)

We just re-created the replication.

Adding the logins into db_owner role is enough.

I guess sazzemokhalef installed the evaluation of Enterprise Edition 😛

Never do this before, but, I guess you have to empty those LDFs first, then backup, then, restore.....

sp_msforeachdb 'use ? select db_name(), name from sysobjects where type = ''tr'''

Ours is not related to backup. Still not sure what's going on. (Environment: SQL2000 Enterprise Edition + SP4 + Hotfix2187 + Windows2003 + IA64-bit)