Post reply

Restore from System backup without bak file?

  • September 5, 2003 at 3:45 pm

    #83163

    Can I recover a database using only the system backups of the .MDF and .LDF files? Would I use attach database or try to slip the files into place with SQL Server stopped. (Of course, all of my databases have SQL backups but I might need to bail out a coworker.)

  • September 5, 2003 at 4:57 pm

    #472910

    When you backup system files do you backup open files? If not you may find they where skipped by the backup.

    Steven

  • September 5, 2003 at 7:43 pm

    #472916

    But as for answer to what to do. If you have good system files then yes sp_attach_db or sp_attach_single_file_db if the LDF has any issues.

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

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