Skip to main content
2 of 2
added 20 characters in body
Mark Storey-Smith
  • 31.9k
  • 9
  • 90
  • 125
RESTORE DATABASE Backup_Test
FROM DISK = 'C:\SQLBackup\Backup_Tesk.bak' \\\Stored in the destination
WITH REPLACE,
MOVE 'Backup_Test' TO 'E:\Program Files\Microsoft SQL Server\MSSQL10.SPDEV\MSSQL\DATA\Backup_Test.mdf',
MOVE 'Backup_Test_log' TO 'F:\Program Files\Microsoft SQL Server\MSSQL10.SPDEV\MSSQL\Data\Backup_Test_log.ldf'

Only you need add comma after REPLACE key

sairam
  • 291
  • 3
  • 5
  • 12