CODEWITHSUNDEEP
sqlsql-server
Anton I
Anton I

Reputation: 3

Can't restore a SQL Server database from a backup file - Error: 102

When I try to restore a SQL Server database, I get:

"An exception occured while executing a Transact-SQL statement or batch. Incorrect syntax near 's' Unclosed quotation mark near character string ". (Microsoft SQL Server, Error:102)"

I am not using any script, just clicking "Restore Database", selecting the file (it has no extension, by the way), and get this error.

I tried to search for a solution, but can't find anyone that had a similar problem. I would really appreciate any input!

Thanks!

Upvotes: 0

Views: 4837

Answers (3)

jim
jim

Reputation: 11

Make sure that you didn't name the directory using special characters. For example, I named my directory SQLDB's\ and got that error. To resolve it, I removed the ' and it worked.

Upvotes: 1

Melanie Caldwell
Melanie Caldwell

Reputation: 1

It is a permission issues for the SQL Server database not user. Just try to move your *.bak to the data directory where other files kept. Now repeat that process again.

If you find it helpful then, mark it as the correct answer.

Good Luck!

Upvotes: 0

sarath
sarath

Reputation: 314

This is due to permission problem.First you need to move the *.bak file to the data-directory of the SQL-server .. then try again..

Upvotes: 0

Related Questions