sql server 2016

sql server 2016

Peter Allen -
Кількість відповідей: 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.

Середня оцінка: -
У відповідь на Peter Allen

Re: sql server 2016

William Lu -
Фото Particularly helpful Moodlers

Moving to General help forum....

Середня оцінка: -
У відповідь на Peter Allen

Re: sql server 2016

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


Середня оцінка:Useful (1)