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 '.