Posted by Erland Sommarskog on 10/01/47 11:40

Matik (marzec@sauron.xo.pl) writes:
> You've mentioned, that the backup shouldn't affect performance ... but
> it might affect IO operations (post regarding backups). The problem is,
> I've a lot of insert and update operations by the running system.
> Regarding to that, if there will be a backup performed, which already
> affect disk write procedure, additionaly, there can be not so much
> space for this processes running (??).

Are you placing the backup on the same disk as where the data or log file
is? That would not be a good idea anyway.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: fetching unique pins...
• Prev in forum: Re: torn page detection and auto shrink: performance?
• Thread view: Re: torn page detection and auto shrink: performance?

[Reply to this message]