-- 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
SQL script that writes sql (DLL or DML) script for DBA and Developer for MS SQL Server 2005 or 2008 or R2
Monday, August 2, 2010
Create dump device dynamicly on the fly.
--dump device Create dynamicly
Labels: SQL
Scripts,
SQL Server
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment