Post reply

how to create new db from .mdf .ldf

  • April 21, 2005 at 4:27 am

    #87297

    I have a requirement to create a new db from copies of an existing db's .mdf and .ldf files. The new db will reside on the same server as the original db but will have a different name. How do you do this?

    thanks

  • April 21, 2005 at 4:48 am

    #554026

    EXEC sp_attach_db @dbname = N'<>',

    @filename1 = '<>',

    @filename2 = '<>'

    LinkedIn Profile

  • April 21, 2005 at 7:19 am

    #554065

    First you must have these copies. You can not atach these files if they depend to original DB. They can not be shared to other DB at the same time

  • April 21, 2005 at 9:00 am

    #554109

    If the original database is present, why not make a backup of that database and then restore it with a different name for the database and the dat files.

     

    Dave

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

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