tsql - Microsoft SQL Server Differential Backup -


i creating differential backups of database every 4h 1 file. today wanted restore latest backup, doesn't work.

if try restore in sql management studio, doesn't recognize full backup. when browse restore point 81 (out of 150), recognizes full backup , able restore it. when choose point after 81, stuck in loop.

i checked headers of backup file , found odd. backups 1-81 have same differentialbaselsn , differentialbaseguid, after 81, changed new lsn , gui.

is problem, why doesn't recognize after 81? can change lsn , guid manually?

thanks!


Comments

Popular posts from this blog

html - How to set bootstrap input responsive width? -

javascript - Highchart x and y axes data from json -

javascript - Get js console.log as python variable in QWebView pyqt -