Does A Backup Take Longer When Files Are Locked? in Server, SBS and Multi Server Posted August 13, 2003 · Report reply Hello, We have a Windows 2000 Server box which hosts a SQL Server. When the Server is up, naturally most of the tables and databases are in use, and cannot be backed up. We rely on the SQL Server application to manage live backups of the databases to another location, which Retrospect backs up. However, I'm wondering if this machine's backups take longer to complete because these files are failing to be backed up. It's obviously a waste of time for Retrospect to back up these folders, but how *much* of a waste of time? Is there a way to quantify this? Should I actually exclude the directory holding all of the databases from being backed up, and if so, would that appreciably increase the speed of my backups for this machine?