SQL 2000 Transaction Log backups

[paul172]

Hi,

I am using the Full recovery model on SQL Server 2000, if I was to schedule the TXN log backups to run, say three times a day, would this prevent users from using the system related to the database, or would it not make a difference to the front end?

Also, when I create a backup job in Enterprise manager to backup the transaction logs, the jobs do not appear in the backup list, however do appear under the SQL Agent Schedule list, does anyone have any ideas why this would be happening.

Thanks

Paul

 

[nigelrivett]

Might slow things down a bit while the backup is taking place but that's all.

I would code the backup yourself and schedule it then you will know what it is doing.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.