Post reply

HOW will I restore it

  • October 12, 2011 at 11:44 pm

    #244571

    I have the database size of 1.6 TB and 300 GB of backup zip file which on extraction becomes 1TB needs to be restored on the database and in data drive the space left is 325 GB.

    HOW will I restore it?Is any possibilty?

    Thanks

  • October 12, 2011 at 11:53 pm

    #1393802

    Nope. To restore that, you need the 1.6TB of space.

    Or buy a 3rd party tool like SQL Virtual Restore.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 12, 2011 at 11:58 pm

    #1393805

    Thanks Gila,

    The running database size is 1.6 TB....I only need to restore 300GB zip on the database

    Thanks

  • October 13, 2011 at 12:03 am

    #1393811

    If you are restoring that database, you need 1.6TB of space to restore it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 13, 2011 at 12:20 am

    #1393821

    gail may I know reason?

    Thanks

  • October 13, 2011 at 2:17 am

    #1393856

    may I know reason?

    I assume this is full backup and at the time of restore, it will try to make the database in the state it was at the time of backup (i.e. 1.6 TB). I am not sure but it may demand more space for tempdb operations as well.

  • October 13, 2011 at 6:48 am

    #1393979

    forsqlserver (10/13/2011)

    gail may I know reason?

    Your backup file contains only used pages from your data and log files.

    Your database's size is 1.6 TB. This doesnt mean the entire space will be used by data. Some portion of the files will be empty.

    When you restore the backup file, it will create the database as it was on the source server - 1.6 TB of file space.

  • October 13, 2011 at 8:02 am

    #1394037

    forsqlserver (10/13/2011)

    gail may I know reason?

    Because it needs to recreate the database as it was at the time of backup, a 1.6TB sized database.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 13, 2011 at 8:26 am

    #1394076

    As in 100% exact copy in every way. Size included.

  • October 13, 2011 at 8:27 am

    #1394079

    This will allow you to mount a copy of the db without doing the restore.

    Free trial : http://www.red-gate.com/products/dba/sql-virtual-restore/

  • October 13, 2011 at 11:20 am

    #1394251

    You will need the full 1.6TB of space to restore your database. However you can create mutiple filegroups and files to create secondary data files on to different disks. I suggest you should use mutiple data files to save yourself from I/O contention

  • October 16, 2011 at 11:48 pm

    #1395135

    Thanks:-)

    Thanks

Viewing 12 posts - 1 through 11 (of 11 total)

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