yet another backup script using litespeed or native backup

Total article views: 208 | Views in the last 30 days: 14

 Rate this |   Join the discussion |  Briefcase

Updated! Now supports both SQL Litespeed and native backup commands in one script! Several new bug fixes please see the header of the script. Error messages to add are now at the bottom of the script! This stored procedure will backup a single database or all databases it will also perform ether a full, diff, or tlog backup. This uses SQL LiteSpeed or native backup provided by SQL Server this stored procedure is designed to take x parameters: @dbname : required, this is the database you wish to backup null or comma seperated list @bktype : required, this is the type of backup 0=full,1=diff,2=tlog @bkpath : required, this is the path can be a drive letter i.e. c:\bak or a unc \\myserver\bak @bkpathhold : required, this is the directory that backups are spooled to first can be the same as the @bkpath @wtcnt int : Default 60, this sets the maximum number of wait loops @sls tinyint : Default 1, this sets the default action to backup using SLS if it is available usage usp_backup2 ,2,'',''

Total article views: 208 | Views in the last 30 days: 14