Posted by DataPro on 10/02/03 11:48

New to Sql Server, running SQL Server 2000.

Our transaction log file backups occasionally fail as the size of the
transaction log gets really huge. We'd like to schedule additional
transaction log backups. Does that require an exclusive on the database
or can the db be used during a transaction log backup?

Also, does switching to a bulk mode recovery model before a bulk
operation then switching back to full recovery mode after present any
issues?

Thanks in advance.

• Next in forum: Re: What permissions do I need to manage users?
• Prev in forum: Re: converting integer zipcodes to a 5 character char
• Thread view: Question on Transaction Log Backups

[Reply to this message]