SQL 2000 - How to automate incremental backups

How to you automate SQL Server 开发者_运维知识库2000 incremental backups using SQL Server Agent and change the backup up name so that it has the current timestamp of when it gets backed up?

Tweak this backup log script to get what you are after:

DECLARE @date varchar (14),
        @disk varchar (255),
        @File varchar (260),
        @cmd varchar (255)
 SELECT @date = convert (varchar(12) , getdate(), 112) + 
               substring (convert (varchar(12) , getdate(), 114),1,2) + substring (convert (varchar(12) , getdate(), 114),4,2) + substring(convert (varchar(12) , getdate(), 114),7,2)
select @disk = '\\' + @server + @path + @database + '\' + @database + '_tlog_' + @date + '.TRN'

BACKUP LOG @database  TO DISK = @disk 

Here's a nice overview of the options at MSDN. Basically you'll have to write a T-SQL script, or a combination of a batch scheduled task with a SQL Server scheduled task.

If you're lazy, check out RedGate Backup. It does pretty much all you ask with its wizard.