Reply To: Getting SQL Error 3159
Lincoln Burrows ~
Modified: 29-Jul-2015 ~ ~ 1 Minute Reading
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.