December 2, 2015 at 8:18 am
I recall a situation where I had to restore a database but it got stuck in a Restoring State. Probable because the options that I selected at some point in time and some other factors.
When should the backup of the tail of the backup be performed and when should it not?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 2, 2015 at 8:29 am
Technically, only if you want to restore to a point in time between the last log backup and the "incident". However, I always do in a DR scenario...
Jared
CE - Microsoft
December 2, 2015 at 8:32 am
during a failover where you are using log-shipping and you want to swap the roles of the servers
---------------------------------------------------------------------
December 2, 2015 at 8:39 am
When you want to make the database unavailable after the backup completes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply