I need to restore a backup of an SQLSERVER database (Ac_Fli) to a different db (Ac_Trn). Using the SQL Management Studio restore tool has given me the following script:
RESTORE DATABASE [Ac_Trn]
FROM DISK = N'\\SQLSERVER\Backups\Ac_Fli.bak'
WITH FILE = 1,
MOVE N'AC_Fli_Data' TO N'C:\SQL DATA\ASL\Ac_Trn.mdf',
MOVE N'AC_Fli_Log' TO N'C:\SQL DATA\ASL\Ac_Trn_log.ldf',
NOUNLOAD, REPLACE, STATS = 10
GO
I think it should be:
RESTORE DATABASE [Ac_Trn]
FROM DISK = N'\\SQLSERVER\Backups\Ac_Fli.bak'
WITH FILE = 1,
MOVE N'AC_Trn_Data' TO N'C:\SQL DATA\ASL\Ac_Trn.mdf',
MOVE N'AC_Trn_Log' TO N'C:\SQL DATA\ASL\Ac_Trn_log.ldf',
NOUNLOAD, REPLACE, STATS = 10
GO
Which version is right?