I am developing a backup strategy which includes backing up a database as well as some extra files that are supposed to be synchronous with some data stored in the database.
Pause sql services
Warn all that about to stop sql services
{wait 5-10 minutes}
Stop sql services
Copy extra files to backup location
{Perform database backup to backup location}
Start sql services
My question is during the step {Perform database backup to backup locaton} what is the best way to do this so that you know that nobody is connecting during.
I tried using the start in single mode and it seemed to hang (I waited for a while). Should I try changing the actual database's properties to single mode and assume the database backup is the one connection which would let me know that the database is synched with the extra files?
Any ideas would be greatly appreciated.
JB
Pause sql services
Warn all that about to stop sql services
{wait 5-10 minutes}
Stop sql services
Copy extra files to backup location
{Perform database backup to backup location}
Start sql services
My question is during the step {Perform database backup to backup locaton} what is the best way to do this so that you know that nobody is connecting during.
I tried using the start in single mode and it seemed to hang (I waited for a while). Should I try changing the actual database's properties to single mode and assume the database backup is the one connection which would let me know that the database is synched with the extra files?
Any ideas would be greatly appreciated.
JB