Restoration Part-3

Partial restore of the primary and filegroups A and C.

RESTORE DATABASE adb FILEGROUP='A',FILEGROUP='C'

FROM partial_backup

WITH PARTIAL, RECOVERY;

At this point, the primary and filegroups A and C are online. All files in filegroup B are recovery pending, and the filegroup is offline.

Online restore of filegroup B.

RESTORE DATABASE adb FILEGROUP='B' FROM backup WITH RECOVERY;

 Is it possible to perform a point in time recovery with Bulk Logged recovery model?

Yes, it is possible to perform a point in time recovery with Bulk logged recovery model till the time we don’t perform any minimal logged operation on the database.

 

What is piecemeal Restore?

A piecemeal restore sequence restores and recovers a database in stages at the filegroup level, beginning with the primary and all read-write, secondary filegroups. Piecemeal restore process allows us to restore the primary filegroup first and the database can be online and the remaining filegroups can be restored while the recovery the transactions are running on primary. Mostly suitable for data warehousing databases.

 References: Thanks to the all the SQL Server techies who wrote and shared the valuable information in the below blogs which helped me a lot to prepare this series of Questions. Also big thanks to Microsoft Documentation which contains each and everything about their product.

How you consider the recovery model between Full recovery model and Simple recovery model?

If you are dealing with huge amount of data and failure chances are also less, you should use the simple recovery model.

If data failure risk is very high, you should use the full recovery model.

 What are the three basic phases for database recovery?

·         Analysis

·         Redo – rolls forward committed transactions

·         Undo – rolls back any incomplete transactions

What is a point in time recovery?

A point in time recovery is restoring a database to a specified date and time. When you have completed a point in time recovery, your database will be in the state it was at the specific date and time you identified when restoring your database. A point in time recovery is a method to recover your database to any point in time since the last database backup.

 What do you require for point in time recovery?

In order to perform a point in time recovery you will need to have an entire series of backups (complete, differential, and transaction log backups) up to and/or beyond the point in time in which you want to recover.

 I’ve just deleted a table! I know it is in the log. How do I get it back?

 If the tables were dropped, ApexSQL Recover can recover them even from databases in the simple recovery model. ApexSQL Recover can recover both table structure and table records.

Another approach is,  You should immediately take a log backup of your database and need to perform a process called a point in time recovery.

Please visit other related articles...

https://sqldbaiq.blogspot.com/p/restoration.html
https://sqldbaiq.blogspot.com/p/restoration-part-2.html
https://sqldbaiq.blogspot.com/p/restoration-part-3.html
https://sqldbaiq.blogspot.com/p/restoration-part-4.html
https://sqldbaiq.blogspot.com/p/restoration-part-5_16.html
https://sqldbaiq.blogspot.com/p/restoration-part-6_16.html

https://sqldbaiq.blogspot.com/p/restoration-part-7.html

References: Thanks to the all the SQL Server bloggers who wrote and shared the valuable information on their blogs which helped me a lot to prepare this series of Questions. Also big thanks to Microsoft Documentation which contains each and everything about their product.