Monday, August 2, 2010

Create dump device dynamicly on the fly.

--dump device Create dynamicly

-- dumpdevice full diskbakup
Select 'EXEC master.dbo.sp_addumpdevice  @devtype = N''disk'', @logicalname = N''' + name + '_DUMP'', @physicalname = N''E:\MSSQL\BACKUP\' + name + '_DUMP.BAK'''
from sys.sysdatabases

-- dumpdevice Diff diskbackup
Select 'EXEC master.dbo.sp_addumpdevice  @devtype = N''disk'', @logicalname = N''' + name + '_DIFFDUMP'', @physicalname = N''E:\MSSQL\BACKUP\' + name + '_DIFFDUMP.BAK'''
from sys.sysdatabases

No comments:

Post a Comment