I need to take a data backup for 10 GB avery active database during
production time. Is it affect the server performance? generate locks....
thanksBackup doesn't lock data or wais for locks. But it will consume resources (r
eading all data,
possibly from disk if not in cache and writing the data to backup media).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mecn" <mecn2002@.yahoo.com> wrote in message news:%231RMCKNtHHA.4600@.TK2MSFTNGP03.phx.gbl...
>I need to take a data backup for 10 GB avery active database during product
ion time. Is it affect
>the server performance? generate locks....
> thanks
>
Sunday, March 11, 2012
Backup data during production time
Labels:
active,
affect,
avery,
backup,
database,
duringproduction,
generate,
microsoft,
mysql,
oracle,
performance,
production,
server,
sql,
time
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment