sql server 2016

Re: sql server 2016

by Harry Nolen -
Number of replies: 0

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)