I have one SQL server 2008 R2 Cluster instance running and there are 2 databases aligned with the instance. I require to take tail log (transaction log) backup of the databases.
While taking the Backup of Transaction log (go to Task-- >Backup database--> Options---> Go under Transaction Log section--> Select Backup the Tail of the log and leave the database in the restoring state), it says that the users are connected with the data base. In order perform the step, we need to disconnect all the user connections already established with the SQL instance and then perform the Tail log backup activity. But the problem is , the users get connected automatically with a periodicity of 10 seconds as these are Client applications that are establishing the connections with SQL instance and I do not have control over that. Can any one suggest a possible way to achieve my objective.
I am using SQL server 2008 R2 version of SQL. The OS is Windows server 2008 R2. Please note that the client applications can not be disconnected for a long span of time (maximum 20 mins) and needs to be reconnected automatically connected after 20 mins. So I require some sort of mechanism through which SQL server instance refuses any inbound connection requests coming to it for 20 mins.