copying .mdf and .ldf files

  • The problem the OPs encountered is the failure to attach databases which were not originally detached.  I wouldn't know the internals of the differences between a shutdown and a detach.

    From Books Online on sp_detach_db

    sp_attach_db should only be executed on databases that were previously detached from the database server using an explicit sp_detach_db operation.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

Viewing post 16 (of 15 total)

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