sql server 2016

sql server 2016

by Peter Allen -
Number of replies: 3

Some of databases were spoilt, one of files got error - Corruption on non-clustered indexes. I applied some recovery protocols, one of them SQL Server Management Studio. They didn't assist. I have to restore mdf database, but I have no idea what to do.

Average of ratings: -
In reply to Peter Allen

Re: sql server 2016

by Harry Nolen -

You may apply one of 3 methods below to solve the issue or make use of SQL Server Restore Toolbox, software was especially created for complicated cases.

 

1) Recover the database manually with following command.

RESTORE DATABASE database_name WITH RECOVERY
2) Recover the database with the last log file.

RESTORE LOG database_name FROM backup_device WITH RECOVERY

3) Recover the database when bak is restored

RESTORE DATABASE database_name FROM backup_device WITH RECOVERY


Average of ratings: Useful (1)