|
Friday, 14 January 2011 09:59 |
|
DECLARE @DBBackupCode NVARCHAR(MAX)
SET @DBBackupCode ='BACKUP DATABASE [DANAME]
TO DISK = N''D:\SQLDATA\Backup\DBNAME.bak''
WITH INIT, NAME = N''DBNAME-Full Database Backup'',
SKIP, NOREWIND, NOUNLOAD, STATS = 10';
execute [LINKEDSERVERNAME].master.dbo.sp_executesql @DBBackupCode
_________________________________________
|
