Posted by Robert Klemme on 10/02/60 11:48

DataPro wrote:
> 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?

It doesn't make sense to switch back and forth. You can permanently
switch to bulk logged because different logging for bulk operations is
all this recovery model is about.

See Microsoft's documentation for more details:

http://technet2.microsoft.com/WindowsServer/en/Library/1d76e446-3122-4f2d-a696-1e260ae740f91033.mspx?mfr=true

Kind regards

robert

• Next in forum: Book contrasting Oracle and MS SQLServer?
• Prev in forum: Re: What permissions do I need to manage users?
• Thread view: Re: Question on Transaction Log Backups

[Reply to this message]