Post reply

Back up restore

  • January 15, 2009 at 3:07 pm

    #200120

    Hi all..

    I have a .bak file of 2.5 GB.

    Space on C drive is 1.5 Gb and D is 1.5 GB.

    Is it possible to restore 1 Gb of data on C drive and remaining on D drive?

    Please let me know if any options exists....

    Thanks in advance

    Shree

  • January 15, 2009 at 3:13 pm

    #927761

    Not if the database that was backed up contained one mdf file. If it had a mdf and a ndf, each under 1.5Gb, you could do it but not if it's a mdf file of 2.5Gb.

    -- You can't be late until you show up.

  • January 15, 2009 at 3:17 pm

    #927764

    Thanks Terry..

    Yes it has only 1 MDF file.. no ldf files..

    Shree

  • January 15, 2009 at 3:24 pm

    #927766

    Shripati - To get more details on the space required when doing the restore you can run the following;

    restore filelistonly from disk = 'D:\YourFolder\YourBackup.bak'

    The output from that will show what the file sizes were at the time of backup and should give you a good idea of what space you will need for the files when you restore.

    HTH

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

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

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