Post reply

Best Practice to Backup teh Database

  • September 30, 2009 at 10:39 am

    #385472

    Hello,

    We use Symantec as our backup system, and it is backed to the Tape, Restore Process is very slow,

    Could someone advice How the automation backup can be done of SQL 2008 please,

    Thanks,

    Dave

  • September 30, 2009 at 12:24 pm

    #1060122

    backup to disk, compress and/or encrypt and then move the files to multiple other disk locations, one of which can be backed up to tape.

    The probability of survival is inversely proportional to the angle of arrival.

  • September 30, 2009 at 12:26 pm

    #1060125

    thanks, the problem is we do not have the compress option,

    Dave

  • September 30, 2009 at 12:27 pm

    #1060127

    Can we do the automation for the disk backup of SQL 2008, please Advice

  • September 30, 2009 at 12:39 pm

    #1060130

    You can set up a SQL maintenance task to back up whatever DBs and/or translogs you want. I generally set up my own translog backup procedures for log shipping though.

    The probability of survival is inversely proportional to the angle of arrival.

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

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