Post reply

Create new DB but with existing Data and Log file

  • February 5, 2016 at 6:58 am

    #315630

    I have existing data and log files which I want to access by creating a new db and attaching these files to.

    What steps do I need to follow to create a new db and then attach the files to it to allow me to see the data?

    I don't know how the db data and log file were defined in terms of size but I can see the data file is about 160MB and the log file appears to be 2mb.

    Any pointers or help would be appreciated.

  • February 5, 2016 at 7:03 am

    #1856824

    (1) Take the database offline

    (2) Copy the files to new names and/or locations

    (3) Bring the database back online

    (4) Create a new database by attaching the new files

    John

  • February 5, 2016 at 7:17 am

    #1856834

    Thanks John

    Nice and simple - now working.

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

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