Terminate Users in Logshipping Restoration.
In SQL Server default logshipping options its very much avilable. While testing I am finding Red-Gate is unable to terminate usres by default.
BTW, is this feature avilable in latest versions?
****************** here is the error code*************
SQL Backup v18.104.22.1685
Restoring Logshipping_test (transaction logs) from:
VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had
SQL error 3013: RESTORE LOG is terminating abnormally.
SQL error 3101: Exclusive access could not be obtained because the database is in use.
SQL Backup exit code: 1010
SQL error code: 3101
(10 row(s) affected)
(3 row(s) affected)
Server: Msg 50000, Level 16, State 1, Line 6
SQL Backup job failed with exitcode: 1010 SQL error code: 3101