Date: 3/25/2004 10:21:48 AM
From: Driscoll, David J.
Subject: RE: RE: SQL Litespeed vs Backup Exec
One way...
CREATE TABLE #OSQLOut (
OSQLResults varchar(255))
DECLARE (at-sign)Command nvarchar(1024)
-- build the command string.
SELECT (at-sign)Command = 'OSQL -E -w120 -Q'EXECUTE
Master.dbo.xp_Backup_Database (at-sign)Database = ''' + (at-sign)DatabaseName + ''',
(at-sign)FileName = ''' + (at-sign)BackupFile + ''', (at-sign)Init = 1''
TRUNCATE TABLE #OSQLOut
--- PRINT (at-sign)Command --- debug
INSERT INTO #OSQLOut EXECUTE Master.db
Read all of the Message >>
