Incorrect syntax near 't'. in SQL SERVER 2012

manikandanmanikandan Member Posts: 160
edited 2014-05-15 in SQL General
Hi
i am Try to restore a DB that time i will get Error Message Like this :


TITLE: Microsoft.SqlServer.ConnectionInfo

An exception occurred while executing a Transact-SQL statement or batch.

ADDITIONAL INFORMATION:

Incorrect syntax near 't'.Unclosed quotation mark after the character string ''. (Microsoft SQL Server, Error: 102)

For help, click: http://go.microsoft.com/fwlink?ProdName ... nkId=20476

BUTTONS:

OK
](*,) ](*,) ](*,)

Comments

  • thulasithulasi Member Posts: 12
    Hi,

    In sql server config manager, set the parameter as shown in the attachment in the sqlexpress properties.

    This may resolve ur error(add only the highlighted one)

    :)
  • manikandanmanikandan Member Posts: 160
    thulasi wrote:
    Hi,

    In sql server config manager, set the parameter as shown in the attachment in the sqlexpress properties.

    This may resolve ur error(add only the highlighted one)

    :)

    Hi,
    have changed as "-dC:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-t4616"

    still i am getting the same Error.kindly help me to solve this problem.
    ](*,)
Sign In or Register to comment.