• GilaMonster (1/8/2013)


    John Mitchell-245523 (1/8/2013)


    It will depend on whether the database was cleanly shut down - it's possible that the files will be corrupt otherwise.

    That's attaching without the log file. When you have both files, doesn't matter if SQL was cleanly shut down or not.

    Thanks Gail - I didn't realise that. Do you happen to know whether it also applies if, for example, the LDF and MDF were backed up using open file agents?

    John