Post reply

Restore urgent

  • June 27, 2008 at 9:27 am

    #188529

    Hi all,

    I am given a backup set of a database which orginally has multiple mdf files in it. Now i am asked to restore it to a new database with single mdf file.

    plz let me know it is possible or not.

    i tried to to give the same mdf file in restore as file...but it gave error as it was claimed by someother original file.

    thanks in adv.

  • June 27, 2008 at 12:29 pm

    #835573

    Unfortunately, I know of no way to do this other than restoring as multiple files, emptying the files, then removing the files

    You should look into the "EMPTYFILE" option of the DBCC SHRINKFILE command. Running this command will re-allocate all the pages of the file being shrunk to each of the remaining files.

    Once each file is "empty", you can alter the database to remove them.

    Kyle

  • June 27, 2008 at 10:30 pm

    #835710

    Hi kyle,

    thanks for the information. thats what we i was thinking.

    many thanks

    cheers

    santhu

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

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