Search code examples
sql-serverdatabase-administrationdatabase-backupsdatabase-restoreerror-log

Error message in restoring database

I saw this error message occurs during a restore operation, I check database integrity in source server with Ola Hallengren script, database is OK.

Error-Log enter image description here

Error enter image description here

Solution

  • The problem was solved

    RESTORE DATABASE My_DB FROM 
DISK = 'D:\My_DB.bak' WITH MOVE 'My_DB_Data' TO 'D:\Data\My_DB_Data.mdf', 
MOVE 'My_DB_Data_New_01' TO 'D:\Data\My_DB_Data_New_01.ndf',
MOVE 'My_DB_Data_Current_01' TO 'D:\Data\My_DB_Data_Current_01.ndf',
MOVE 'My_DB_Data_Current_02' TO 'D:\Data\My_DB_Data_Current_02.ndf', 
MOVE 'My_DB_Log' TO 'F:\Log\My_DB_Log.ldf' ,keep_cdc, NOUNLOAD, STATS = 10

    for more information check this link