Article 3.6.1W : How to solve Incorrect syntax near 's' when restoring DB.

Article 3.6.1W : How to solve Incorrect syntax near 's' when restoring DB.

When restoring DB, Incorrect syntax near 's' error will popup.



To solve this, follow the below steps.

Step 1 : Go to DB restore page (Select DB -> right click -> select Tasks -> Restore -> Database).
Step 2 : Click options.
Step 3 : Enable overwrite & close application (as shown in the below pic).

Step 4 : Click general, select DB & click OK to restore.

Note: Restoring DB should have .bak extension. Place the DB file in default SQL backup in c drive.

*** End of document ***