Agent Jobs

Backup All Databases With LiteSpeed

use master
go
set nocount on
select ‘exec master.dbo.xp_backup_database @database = ”’ + name + ”’, @filename = ”D:\MyPath\’ + name + ‘ LiteSpeed_Full.BKP”, @init = 1, @logging = 0, @with = ”SKIP”’ + char(10) + ‘go’ + char(10) from sysdatabases where name not in (‘tempdb’)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s