Incorrect syntax near 't'. in SQL SERVER 2012

manikandan

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

---

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

thulasi

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)

manikandan

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.
](*,)