Error in Sql server query

Prabu Spark

13y1.6k

Hi sir,
I am getting the error

"Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '+'.
Msg 319, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon." after executing the below query. Kindly give me the solution for this problem

Query:
----------------

declare @backuptime varchar(50)
set @backuptime=convert(varchar,getdate())
BACKUP DATABASE checking TO DISK = 'd:\testdb1_'+@backuptime+'.bak' WITH FORMAT, MEDIANAME = 'checking', NAME = 'Full backup of my database';
GO

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kunal Vaishya13y ago
Hi , You can try this also more help full

declare @backuptime varchar(50)
declare @backupDisc varchar(150)
Set @backuptime=Convert(varchar,getdate(),105)
Set @backupDisc = 'd:\testdb1_'+ Cast(@backuptime as varchar(100)) +'.bak'
Select @backupDisc

BACKUP DATABASE checking
TO DISK = @backupDisc
WITH FORMAT,
MEDIANAME = 'checking',
NAME = 'Full backup of my database';
GO
0
Kunal Vaishya13y ago
declare @backuptime varchar(50)
declare @backupDisc varchar(150)
Set @backuptime=convert(varchar,getdate())
Set @backupDisc = 'd:\testdb1_'+ Cast(@backuptime as varchar(100)) +'.bak'
Select @backupDisc

BACKUP DATABASE checking
TO DISK = @backupDisc
WITH FORMAT,
MEDIANAME = 'checking',
NAME = 'Full backup of my database';
GO
0
Iftikar Hussain13y ago
Hi,
Try like this

declare @backuptime varchar(50)
set @backuptime=convert(varchar,getdate())
declare @DiskPath varchar(100)
SET @DiskPath='d:\testdb1_'+ @backuptime + '.bak'
BACKUP DATABASE checking TO DISK = @DiskPath
WITH FORMAT,
MEDIANAME = 'checking',
NAME = 'Full backup of my database';
GO

Regards,
Iftikar
0