Search code examples
sql-serverbackupdatabase-restore

Attach database with NORECOVERY

Is there a way to attach a SQL Server mdf/ldf files such that the database is in Restoring mode and we can restore log backups on top of it.

I have a hardware array snapshot (crash consistent) that contains the mdf/ldf files. I need to attach these files to another SQL Server instance and then do log restores for a point in time recovery(using stopat)

The CREATE DATABASE .. FOR ATTACH command brings the database online. Log restore cannot be done on an online database.

Is there a way to accomplish this?

Solution

  • No. Unfortunately. Vote for the feature here: DCR - Attach database with NORECOVERY