|
Home > Archive > SQL server exams > December 2002 > easy Backup question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
easy Backup question
|
|
| czeddie 2002-12-07, 8:07 pm |
| Can users perform querys or do anything with a database while it is being backed up? | |
| czeddie 2002-12-09, 12:15 am |
| Well, a source on the net says... "no, you cannot access a database while it's being backed up". He says that is the norm anyhow, but there are applications/ways around it.
 | |
| naresh_sky 2002-12-09, 3:35 am |
| hi czeddie
wel i am not a master in sql .
but hoping to be.
as far your question. if i am not wrong.
a user can run the query when the dbase
is backed up.
the back up system reads the transaction
log and marks the check on it before
a dbase is backed up and again it read
all changes which have been written to
log from the time a backup has started
and backup the log also .
that's how it happen if i am not wrong
regards
naresh |
|
|
|
|