Post reply

about backup strategy

  • June 14, 2010 at 12:31 pm

    #222659

    i am a database with following structure having 3 filegroups each having 3 files ,apart from Primary filegroup.ALL filegroups are stored in different drives.Each filegroup size is 10 GB size.

    out of 4 file groups one is readonly.

    i want to create a backup scenerio for efficient maintance of db with the following conditions

    1).when ever need i want to restore the entire db on to different Test machine?

    2).When ever need i want to partialy made online?

    3)when ever need i want to restor the db to a specific point of time?

    4).when required i need to change the recovery model for bulk operations?

    create a backup stratagey for the above all condations?

    plz can any one help me to create the backup stratagy?

    thankyou.

  • June 14, 2010 at 8:38 pm

    #1180176

    What type of class is this for ?

  • June 14, 2010 at 11:44 pm

    #1180199

    vijay82 (6/14/2010)

    1).when ever need i want to restore the entire db on to different Test machine?

    Restore the full backup there

    2).When ever need i want to partialy made online?

    Define 'partially'. Look up file/filegroup backups and restores in SQL books online

    3)when ever need i want to restor the db to a specific point of time?

    Look up Transaction log backups in SQL books online

    4).when required i need to change the recovery model for bulk operations?

    Look up ALTER DATABASE and recovery models in SQL books online.

    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

  • June 24, 2010 at 1:56 am

    #1184363

    Hello Friends......

    Here's a four-step process for creating a backup strategy.

    1.Decide what you need to back up. Do you want to save everything? Only documents you've created? What about application settings? Things you've downloaded?

    2.Decide where to back up your data to. There are plenty of options: a network server, a USB keyring, a Zip disk, a (re)writable CD or DVD, a second hard drive, etc. I don't recommend the last option; a power surge could fry your data and backup simultaneously.

    3.Make it easy to back up your data. Set up your system so that you can back it up with one command. This will take a fair amount of work, but you'll realize its worth when your system crashes.

    4.Make daily backups a habit. The longer the period between backups, the more you have to lose.

    Thanks

    Thanks

    web development

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

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