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
Post a Comment