on 12-09-2008 4:07 AM
Hello everybody, when I had planning the database backup from database planning calander, i have set the msdb, differential backup, on hard disk, then following error is rises
SQL Task information
Jobname: SAP CCMS Diff DB Backup of msdb [20081209074821-2-080000]
Stepname: Step1
Type: TSQL
DB-Name: IDS
Command: ids.sap_backup_diff_databases @dblist="msdb",@r3
db="IDS",@bdev="Drive E",@unload=0,@verify=0,@jo
bname= "SAP CCMS Diff DB Backup of msdb [2008120
9074821-2-080000]"
Task history information
For Run: 20081209 08:00:00
Status: (failure)
Message: 319
Severity: 15
Duration: 0 hours(s) 0 min(s) 0 sec(s)
Last msg: Executed as user: NT AUTHORITY\SYSTEM. DBCC execut
ion completed. If DBCC printed error messages, con
tact your system administrator. [SQLSTATE 01000] (
Message 2528) Incorrect syntax near the keyword '
WITH'. [SQLSTATE 42000] (Error 156) Incorrect syn
tax near the keyword 'with'. If this statement is
a common table expression or an xmlnamespaces clau
se, the previous statement must be terminated with
a semicolon. [SQLSTATE 42000] (Error 319). The s
tep failed.
will anybody tell me the correct reason for the database fail,
I think may be sapce in "@bdev="Drive E" this statement
thanks
Ganesh
I had solved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.