question on backup

Hi,
currently I have set up the complete backup at midnight
and transaction backup every hour. I would like to
schedule some differential backup too.
If the complete backup doesn't finish by the time the
transaction backup needs to kick off, how the server deal
with it?
Same thing if differential backup doesn't finish by the
time transaction backup needs to kick off, how the server
deal with it?
I don't know how the server order the backups if I
schedule complete, differential and transcation backup
all at 12:00:00am?
I need to restore from the backup to recover the primary
server, how can I make sure they have exactly the same
footprint? I am imaging there always some time gap between
I load the backup and bring it online.Jen,
Backup operations to the same database must be serialized.
If a backup job kicks off during another backup of the same database, the
job will blow off.
James Hokes
"Jen" <anonymous@.discussions.microsoft.com> wrote in message
news:057001c3ce6f$e528bd90$a101280a@.phx.gbl...
> Hi,
> currently I have set up the complete backup at midnight
> and transaction backup every hour. I would like to
> schedule some differential backup too.
> If the complete backup doesn't finish by the time the
> transaction backup needs to kick off, how the server deal
> with it?
> Same thing if differential backup doesn't finish by the
> time transaction backup needs to kick off, how the server
> deal with it?
> I don't know how the server order the backups if I
> schedule complete, differential and transcation backup
> all at 12:00:00am?
> I need to restore from the backup to recover the primary
> server, how can I make sure they have exactly the same
> footprint? I am imaging there always some time gap between
> I load the backup and bring it online.|||So it is your respsonsibility to know how long backups take, and schedule
them so they do NOT overlap...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jen" <anonymous@.discussions.microsoft.com> wrote in message
news:057001c3ce6f$e528bd90$a101280a@.phx.gbl...
> Hi,
> currently I have set up the complete backup at midnight
> and transaction backup every hour. I would like to
> schedule some differential backup too.
> If the complete backup doesn't finish by the time the
> transaction backup needs to kick off, how the server deal
> with it?
> Same thing if differential backup doesn't finish by the
> time transaction backup needs to kick off, how the server
> deal with it?
> I don't know how the server order the backups if I
> schedule complete, differential and transcation backup
> all at 12:00:00am?
> I need to restore from the backup to recover the primary
> server, how can I make sure they have exactly the same
> footprint? I am imaging there always some time gap between
> I load the backup and bring it online.