Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: 948 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

Powershell Database Backup Script

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

FORUM

calculating the size required for backup of database

calculating the size required for backup of database

FORUM

xmla script for automate ssas database backup

xmla script for automate ssas database backup

SCRIPT

Backup & Restoration Script

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

FORUM

script for backup files

script for backup files

 
Contribute