1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

How do I create a SQL MDF file

Discussion in 'Other PC Software' started by Grunty, 2008/04/18.

  1. 2008/04/18
    Grunty

    Grunty Inactive Thread Starter

    Joined:
    2002/11/07
    Messages:
    326
    Likes Received:
    0
    I am trying to build a copy of our accounts SQL server, and I know nothing about setting up SQL. The installation notes I have tell me to "Attach database ".

    I find that it needs an MDF file. I cannot detach and copy from the live server because it is in use, but I have a .bak file created by a SQL backup routine every night, can I rename that .mdf and attach?

    Any help gratefully received.

    Ta
     
    Grunty,
    #1
  2. 2008/04/18
    Steve R Jones

    Steve R Jones SuperGeek Staff

    Joined:
    2001/12/30
    Messages:
    12,323
    Likes Received:
    253
    SQL also has a "restore" routine that will use the .bak file.
     
    Steve R Jones,
    #2


  3. to hide this advert.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...