Post reply

Is it possible to create a database with having one .mdf file of another database(resides in diff instance)?

  • December 20, 2012 at 9:47 pm

    #393827

    Is it possible to create a database with having one .mdf file of another database(resides in diff instance)?

  • December 20, 2012 at 10:37 pm

    #1570719

    Yes, You can do it as long as mdf file should reside in different path from the original mdf file.

    Use either sp_attach_single_file_db (deprecated feature) or CREATE DATABASE FOR ATTACH.

  • December 20, 2012 at 10:54 pm

    #1570722

    If that data file is in use, then you can only attach it to the one instance at a time.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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