Sunday, March 11, 2012

Backup data during production time

I need to take a data backup for 10 GB avery active database during
production time. Is it affect the server performance? generate locks....
thanks
Backup doesn't lock data or wais for locks. But it will consume resources (reading 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 production time. Is it affect
>the server performance? generate locks....
> thanks
>

No comments:

Post a Comment