Activity overview
Latest activity by DoraM
The backup itself happens with no problem. It returns 2 result sets even when I specify SINGLERESULTSET option. / comments
The backup itself happens with no problem. It returns 2 result sets even when I specify SINGLERESULTSET option.
Server: Msg 213, Level 16, State 7, Procedure sqlbackup, Line 23
Insert Error: Column name or number of supplied values does not match table definition.
Thats the error I get when I try to run the command with singleresultset option.
thanks,
Dora. / comments
Server: Msg 213, Level 16, State 7, Procedure sqlbackup, Line 23
Insert Error: Column name or number of supplied values does not match table definition.
Thats the error I get when I try to run the ...
capture the message associated with the error
Hi, My backup runs as a t-SQL job with the following syntax.
select @sql = '-SQL "BACKUP DATABASE ADMIN_COMPONENTS TO DISK = ''D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\dbname_200710.sqb''...