Post reply

mdf file

  • July 2, 2003 at 9:01 am

    #81184

    I have recieved a mdf file from one our clients.What is the better way to restore it.

    Thanks

  • July 2, 2003 at 10:04 am

    #463949

    Since you don't have the .ldf file (log file), you will have to use the procedure:

    sp_attach_single_db_file

    See the Books OnLine for more information on the usage and syntax.

    -SQLBill

  • July 2, 2003 at 10:09 am

    #463951

    I think I can use sp_attach_single_db_file

    only when I detach the file using sp_detach_db.

  • July 3, 2003 at 5:34 am

    #464033

    there's also sp_attach_db which has more parameters that you don't need to fill in. In the enterprise manager for SQL2k you can just right click on the "Databases" object under your server and select "All Tasks," then "Attach Database...," then browse to your MDF file.

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

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