1

You can RESTORE the database and leave it in STANDBY mode. Then it will be read-only, but you can still apply additional backups. EG drop table if exists AdventureWorks2017.dbo.foo create table AdventureWorks2017.dbo.foo(id int identity, a int) go backup database AdventureWorks2017 to disk='c:\temp\aw.bak' with init, format insert into AdventureWorks2017....


Only top voted, non community-wiki answers of a minimum length are eligible