Post reply

Need to remove reference to a data file -- database will not start

  • July 26, 2013 at 9:36 pm

    #280966

    I had added a secondary data file to a database. We migrated environments, and the physical drive that I unknowingly created the secondary file on was destroyed w/o backup. I can rebuild the data contained therein (i had only created this 3 weeks ago), but I cannot get the database to start due to the missing file. All other databases in the named instance start up fine.

    How can I remove the references to this data file so that the database will start up using only the primary data and log files? I've searched everywhere for a disk or registry resident startup config that I can edit. Please help - this is a huge mess!

    Thanks,

    Dave

  • July 27, 2013 at 12:22 pm

    #1636416

    do you have a backup of the database? If so restore it using the with move option for the secondary file.

    ---------------------------------------------------------------------

  • July 27, 2013 at 5:57 pm

    #1636434

    Thanks, George.

    I will give that a try.

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

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