retaining the session of the databse
I am connecting to SQL Server database from my application. When backups are performed, I wish to keep the session alive while the database is in either single user mode or read-only mode. But the application is losing connection and is not gaining connection back when the database is back. I see this is not happening with the same application connecting to Oracle.
Please can someone help in resolving this ? Also is there anyother way I can keep the session active and re-connect when the database is back.
I tried db_denydatawriter but this is not working for me. Even though the permission is showing as db_denydatawriter I am able to write to the databse...
Please someone help !!