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
