Post reply

db backup

  • May 11, 2008 at 11:00 pm

    #190411

    i have a db of 70gb.ihave 2 backup devices of 40 gb each.It is possible to take a full back up of my db using these devices.

  • May 11, 2008 at 11:18 pm

    #813609

    Hi,

    Yes, it is possible to do so. In the 'Backup Database' dialog simply add both your devices to the 'Destination' section. The database will backup almost equally onto both the devices...

    Regards...

  • May 11, 2008 at 11:56 pm

    #813617

    thank u

  • May 12, 2008 at 12:36 am

    #813618

    You will need both of the backup files to restore, since the backup will be stripped across the 2. Make sure you don't lose one of thse files.

    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

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

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