Error in Sql server query

Question

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(varchargetdate()) BACKUP DATABASE checking TO DISK = 'd:	estdb1_'+@backuptime+'.bak' WITH FORMAT MEDIANAME = 'checking' NAME = 'Full backup of my database'; GO

Kunal Vaishya · Answer

Hi  You can try this also more help full declare @backuptime varchar(50) declare @backupDisc varchar(150) Set @backuptime=Convert(varchargetdate()105) Set @backupDisc = 'd:	estdb1_'+ 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

Kunal Vaishya · Answer

declare @backuptime varchar(50) declare @backupDisc varchar(150) Set @backuptime=convert(varchargetdate()) Set @backupDisc = 'd:	estdb1_'+ 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

Iftikar Hussain · Answer

Hi Try like this declare @backuptime varchar(50) set @backuptime=convert(varchargetdate()) declare @DiskPath varchar(100) SET @DiskPath='d:	estdb1_'+ @backuptime + '.bak' BACKUP DATABASE checking TO DISK = @DiskPath WITH FORMAT MEDIANAME = 'checking' NAME = 'Full backup of my database'; GO Regards Iftikar