Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

yet another backup script using litespeed or native backup

By Wesley Brown,

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: 947 | Views in the last 30 days: 1
Related Articles

Powershell Database Backup Script

Learn how to write a script for regular database backups using Powershell and SMO.


calculating the size required for backup of database

calculating the size required for backup of database


xmla script for automate ssas database backup

xmla script for automate ssas database backup


Backup & Restoration Script

This script provides very useful information about database backup and restoration.


script for backup files

script for backup files


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones