![]() Update: the 100% status lasted ~5 minutes after a 45 minute restore then finished ![]() Thanks for this article! I can finally " see" how far the backup verification is. Lifesaver and now I have new tools in the toolbox. Thursday, Decem3:12:41 PM - Srinivas Sunkara Exactly the info I was looking to learn about! Thanks for the info about the three phases of restores. WHERE r.command IN ('BACKUP DATABASE','RESTORE DATABASE', 'BACKUP LOG','RESTORE LOG') + CAST((estimated_completion_time %60000)/1000 as VARCHAR) + ' sec' AS est_time_to_go,ĭATEADD(SECOND,estimated_completion_time/1000, GETDATE()) AS estimated_completion_timeĬROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a + CAST((DATEDIFF(s,start_time,GETDATE())%60) AS VARCHAR) + ' sec' AS running_time,ĬAST((estimated_completion_time/3600000) AS VARCHAR) + ' hour(s), ' This is the query I use to get Pct complete for either backup or restores:ĬAST(((DATEDIFF(s,start_time,GETDATE()))/3600) AS VARCHAR) + ' hour(s), ' Keep critical database backups safe using data encryption which was.A backup file retention policy should also be created.To plan the backup strategy and timings accordingly. Backups and restores take considerable amount of resources, so you need.High availability solution can replace it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |