home articles news code blog links search

		sp_SQLLitespeedmaint Author  Jasper Smith Created  16-05-2003 Updated  25-05-2004 Requests  1177 Description This procedure mimics the backup capabilities of xp_sqlmaint but uses SQL Litespeed to perform the database and log backups.Thus you get all the benefits of SQL Litespeed including faster,smaller more secure backups plus the benefits of xp_sqlmaint, standard backup naming,reporting and old backup housekeeping Revision History Author Date Description Jasper Smith 16-05-2003 Initial Creation Jasper Smith 19-11-2003 Added @usexp and @report flags Jasper Smith 10-12-2003 Fix for cmdline and spaces in database names Jasper Smith 19-01-2004 Clean up cmdline job history output Jasper Smith 12-02-2004 Added logging for command line Jasper Smith 05-03-2004 Added output parsing for verify to trap errors for commandline Jasper Smith 12-03-2004 Change to database existence check to cope with autoclose databases Jasper Smith 20-04-2004 Changed version check to allow for running on SQL2005 Jasper Smith 10-05-2004 Added output parsing for backup to trap errors for commandline Jasper Smith 25-05-2004 Modified to allow backup retention using number of files not date View Code Download Code

© Copyright sqldbatips Ltd 2008. Contact webmaster

home | news | articles | code | blog | links | search