Getting SQL Error 3159
Stephen West ~
Modified: 29-Jul-2015 ~ ~ 2 Minutes Reading
- This topic has 5 replies, 3 voices, and was last updated 7 years, 2 months ago by .
Viewing 6 posts - 1 through 6 (of 6 total)
-
Posts
-
Which SQL Server Version you are using right now?
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.
The reason of error is self explained means that the error reason is explained in error message.
Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose.
You need to restore the database from full backup using WITH REPLACE clause something like this:RESTORE DATABASE DATABASE_NAME FROM DISK = 'C:\database.BAK' WITH REPLACE GOTo know more how to fix the Microsoft SQL Server Error 3159, please go this nicely written article. http://www.sqlserverlogexplorer.com/resolve-sql-server-error-3159/
Viewing 6 posts - 1 through 6 (of 6 total)
- You must be logged in to reply to this topic.