Backups

Here is the question, what does SQL Server do with databases that are in use but I am performing a backup. Our company has some kind of software that cannot have a database in use during a backup. I suggested that SQL Server perform it's own backup and
then the can let the tape drives backup my back up. What does SQL Server do in this case?
You are right, SQL Server can do online backups. When you do a database
backup, it backups data files, and after that the portinon of the
transaction log that holds changes made during the data files backup.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:FB7C977B-45A5-4DAD-9B9A-A87F6A229DA2@.microsoft.com...
> Here is the question, what does SQL Server do with databases that are in
use but I am performing a backup. Our company has some kind of software
that cannot have a database in use during a backup. I suggested that SQL
Server perform it's own backup and then the can let the tape drives backup
my back up. What does SQL Server do in this case?
|||SQL Server basically doesn't disturb the users at all while it does a backup. It does a checkpoint, backs up
all data pages and then all log records that were created during the time it took to backup the data pages.
What the users will see is possibly some decreased performance as SQL Server generated I/O while the backup
was running.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:FB7C977B-45A5-4DAD-9B9A-A87F6A229DA2@.microsoft.com...
> Here is the question, what does SQL Server do with databases that are in use but I am performing a backup.
Our company has some kind of software that cannot have a database in use during a backup. I suggested that
SQL Server perform it's own backup and then the can let the tape drives backup my back up. What does SQL
Server do in this case?