December 3, 2003 at 10:20 am
Is it possible to backup a currently runnig database (Solarwinds) using Enterprise Manager? 2nd will it kick users connected to it?
Any Help would be greatly appreciated.
December 3, 2003 at 11:01 am
If you mean "Hot Backups" then, with SQL server it is possible to backups running databases, without stoping the server.
Users won't notice that you are backing up the Db, except for the performance depending on your hardware, etc...
December 5, 2003 at 8:21 am
racosta,
Thanks I appreciate it.
December 5, 2003 at 9:44 am
It depends on how you do your backups. The 'native' SQL Server backups (using the BACKUP tsql command) work while the database is being used.
Using third-party backup tools, can require you to put the database in SINGLE user mode and kick users out.
This is why I use the BACKUP commands to backup to disk and then use my backup software to COPY the backup file to tape.
-SQLBill
December 5, 2003 at 10:32 am
quote:
Using third-party backup tools, can require you to put the database in SINGLE user mode and kick users out.
I believe you must mean OFFLINE (or detaching the database or stopping the server), which will allow backing up the files. The files are still in use by SQL Server in SINGLE_USER mode.
--Jonathan
--Jonathan
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply