Post reply

Recover SQL server database from Windows Bare Metal Backup

  • January 29, 2020 at 4:55 pm

    #3721290

    I need to know if I can recover a sql server database for a previous date (two months ago), from a Windows Server Bare Metal backup. Can I extract just the .mdf and .Idf from that image file to a different location for testing purposes and have it work?

     

    My backup properties show that I regularly include the VSS state, the system state, and EFI system partition.

  • January 29, 2020 at 5:11 pm

    #3721305

    Based on what you say your backup is capturing, I don't think it's getting the filesystem.

    On top of that, I'd expect a chance that even if the filesystem (including the database files) were being backed up, that there's a non-zero chance you'd run into problems attaching the MDF / LDF (in-flight transactions, etc.)

    But, again, first problem is, it doesn't sound like the file system is getting backed up, only enough to get Windows back up and running.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply