0

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
3
Views
8 Years
Discussion Span
Last Post by pacificcode
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.