Member Avatar for dhanashreegd

Dim strSql As String
strSql = " set quoted_identifier off "
strSql &= " declare @strSql varchar(150) "
strSql &= " set @strSql = ""BackUp database SWAMC to disk = 'D:\SWAMC"" + Convert(varchar, getdate(), 112) + Replace(Convert(varchar, getdate(), 108), "":"", """") + "".dbb' with init,skip"""
strSql &= " print @strSql"
strSql &= " exec (@strSql) "
strSql &= "set quoted_identifier on "

Dim SqlCmd As New SqlClient.SqlCommand(strSql, con)
SqlCmd.ExecuteNonQuery()


this give me error in taking backup
Plz help me...................................

  • 2 Contributors
  • 1 Reply
  • 104 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by pacificcode
Member Avatar for pacificcode

Hi,

When trouble shooting VB & SQL I always find it easier to formulate my string variable "strSql" and then output this text to a text message.

Then copy this text string and manually run the string using T-SQL or from the SQL 2005 interface.

This will show if your syntax is being assembled correctly by pointing out where the SQL server is having a problem with the command.

If it runs OK manually, then that would mean that you are not sending it over to SQL in the proper format and you may have issues with " or ' or ''' other related formatting & spacing issues.

Good luck..!
MJ

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.