Reply To: Getting SQL Error 3159

Lincoln Burrows ~ Modified: July 29th, 2015 ~ ~ 1 Minute Reading

July 29, 2015 at 10:34 am #393 Score: 0

Moderator

Karma: 16 pts

Try this query:
RESTORE DATABASE mydb
FROM DISK = ‘C:\Backupmydb.bak’
WITH MOVE ‘mydb_Data’ TO ‘C:\Data’,
MOVE ‘mydb_Log’ TO ‘C:\Data’

May this works perfectly with SQL Server 2012.