Thanks DBA frindeds

       For the Logshipping case, I would perfer to use 'Terminate Users in databases (Recommended)'. It actully kill the processes before restoring the database. And  it's been working fine...

Hi Kelley,

    Here is the error message:

    On Source Server:

    The job failed.  Unable to determine if the owner ('Domain\my account') of job Transaction Log Backup Job for DB...

Thanks Phil,

    I found the way to kill the users before restoring the database in log shipping. In Database Maintence Plans -> select Log Shipping tab -> click edit ->...

Hi Phil,

    I don't have to warn them. I just want to kill the processes before restoring database in log shipping. Please let me know how to set it up.

   ...

Thanks Guys

    Both SQL Server account & SQL Agent account uses a domain account we created. This account has local admin on both SQL Server machines for log shipping. I...

Thanks guys

    sql agent job is running under windows domain accounts, not my account. The job owner is automatically created under my account. Why it fails even if I am...