Monday, March 19, 2012

Backup process lock others out of DB?

I had a backup fail on PM run because of diskspace issue. Fixed that and ran
the job this AM. It just about crippled our DB, and my web-server couldn't
get data, just time outs.
Is this normal for the DB backup to override requests for data? If so are
there other backup software packages to create a .bak file instead of EM's
jobs?
TIA
__StephenNo, its not normal...were you writing to the same disk that the datafile(s)
reside on?
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:O2wtHkv3FHA.1396@.TK2MSFTNGP12.phx.gbl...
>I had a backup fail on PM run because of diskspace issue. Fixed that and
>ran the job this AM. It just about crippled our DB, and my web-server
>couldn't get data, just time outs.
> Is this normal for the DB backup to override requests for data? If so are
> there other backup software packages to create a .bak file instead of EM's
> jobs?
> TIA
> __Stephen
>|||"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:eSJ%23IEw3FHA.696@.TK2MSFTNGP09.phx.gbl...
> No, its not normal...were you writing to the same disk that the
> datafile(s) reside on?
No I write to a separate server for all backups and transaction logs. I
didn't think it was correct either.
Actually my server was getting hammered with batch work at the time. It's
Tues. morning so lets try to batch in 20% of our weekly business. I do a
tran log backup every 15 min and the one this morning at the time things got
hairy was only 514 meg. Normally its in the 5+ meg range. So that massive
file is an indication that I'll be beating on my system hard for the next
hour or two. We are a print shop and we feed 3 Xerox doc-u-beasts doing
financial outputs and checks.

No comments:

Post a Comment