Ruth Posted May 25, 2010 Share Posted May 25, 2010 Ok guys I can't figure this one out. I'm am trying to restore a database. I've created the database and then tired to restore my backup file. Here is my syntax: restore database NorthwindReportData from disk = 'G:\Program Files\Microsoft SQL Server\MSSQL\Backup\NorthwindReportData_FullBackup./BAK' with norecovery, move = 'NWRD_Data' to 'G:\Program Files\Microsoft SQL Server\MSSQL\Data\NorthwindReportData.mdf', move = 'NWRDLog' to 'D:\sql_logs\NWRDLog.ldf' I keep getting the error: Server: Msg 156, Level 15, State 1, Line 4 Incorrect syntax near the keyword 'to' I know the medianame and mediapassword or optional, so what am I doing wrong? R Link to comment https://forums.phpfreaks.com/topic/202879-restore-error-need-help/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.