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...
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 ->...
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...
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...