Restore Database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Restore Database

Author

Topic

dr223
Constraint Violating Yak Guru

444 Posts

Posted - 2011-09-28 : 10:09:54

Hi,

When I use the following code to restore a database I receive the error;

- Incorrect syntax near '-'
- Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminates with a semicolon.

N/B: I have three files to Restore

- goprd-rct.mdf
- goprd-rct_1.log
- test.xml

RESTORE DATABASE gprd-rct
FROM DISK = 'G:\rct\rct.bak'
WITH REPLACE

Thank you

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-09-28 : 10:43:45

RESTORE DATABASE [gprd-rct]
FROM DISK = 'G:\rct\rct.bak'
WITH REPLACE

--
Gail Shaw
SQL Server MVP

paultech
Yak Posting Veteran

79 Posts

Posted - 2011-09-28 : 11:07:02

Hi ,

you may put database name between [] and at the end of the restore statment try to put a semicolon

review the following link

http://www.sql-server-performance.com/2009/previous-statement-must-be-terminated-with-semicolon/

good luck

paul Tech

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-09-28 : 11:21:46

No need for a ;, though it is recommended that all statements be terminated with a ;.
The error about the WITH was a result of the first, of the - in the database name.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources