Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backup Jobs

Author  Topic 

Sarat
Constraint Violating Yak Guru

265 Posts

Posted - 2003-12-08 : 12:22:07
Hi,
When we backup logs every 15 mins or 1 hour or even a full backup while all users are on the system, does it affect even slightly the performance of the database at all?
Thanks,
Sarat.

**To be intoxicated is to feel sophisticated, but not be able to say it.**

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-12-08 : 12:24:10
Yes it does. How much depends on how many transactions have occurred since the last log backup.

Tara
Go to Top of Page
   

- Advertisement -