Hi,
I am trying to restore the database as shown below;
RESTORE DATABASE MarBtch4a
FROM DISK = 'I:\DataMar16\Batch 4a\PseudoAnonymised_OTS_CDB_26480_-_Clinical_Practice_Research_Datalink_CPRD_-_LD8034_20160405.bak’
WITH
MOVE 'PseudoAnonymised_OTS_CDB_26480_-_Clinical_Practice_Research_Datalink_CPRD_-_LD8034_20160405'
TO 'I:\MarBtch4a.mdf',
MOVE 'PseudoAnonymised_OTS_CDB_26480_-_Clinical_Practice_Research_Datalink_CPRD_-_LD8034_20160405_log'
TO 'I:\MarBtch4a_log.ldf'
GO
I receive the errors;
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near 'PseudoAnonymised_OTS_CDB_26480_'.
Msg 132, Level 15, State 1, Line 7
The label 'I' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 105, Level 15, State 1, Line 7
Unclosed quotation mark after the character string '
GO
'.
Please help..
Thanks