Jump to content

restore error need help


Ruth

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.