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

networking - Vagrant-provisioned VirtualBox VM is not reachable from Ubuntu host -

c# - ASP.NET Core - There is already an object named 'AspNetRoles' in the database -

ruby on rails - ArgumentError: Missing host to link to! Please provide the :host parameter, set default_url_options[:host], or set :only_path to true -