Post reply

Backup Devices Vs General Backup

  • September 9, 2008 at 4:57 am

    #197412

    Hi All

    There are 15 databases are existing in the production server.

    Is it best option to choose [Server Objects]->[Backup devices] for taking the backup and keeping all the 15 database backup in single backup file?

    Because if this single backup file been correpted then there will be problem for restoring all the 15 database in the server. Does SQL Server provide any acknowledgment for no correption at backup files.

    Otherwise, taking the backup for each database and having it in file system will be best practice ?

    I appretiate, if any one could give me best solutions.

    Regards,

    Mohanraj Jayaraman

  • September 9, 2008 at 5:47 am

    #868963

    do you mean specifically tape devices or just logical backup devices?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • September 9, 2008 at 5:59 am

    #868970

    "do you mean specifically tape devices or just logical backup devices? "

    I donno whatz "logical backup devices" but when I said Backup Devices, I told Server->[Server Objects]->[Backup Devices]-> Created new backup device ( I donno this step is physical or logical ) and storing into single backup file.

    Thanks to your time taken for the reply.

    Regards,

    Mohanraj Jayaraman

  • September 9, 2008 at 7:51 am

    #869052

    Sounds like you're referring to logical devices, not a separate machine that has tapes.

    I prefer to keep all the databases separate. I don't use backup devices. I backup each database to it's own folder, and then copy those backups to tape

    For instance you could have 1 job that backs up all the databases:

    Backup Database_A to E:\SQL\Backups\Full\Database_A\Database_A_20080906.BAK

    Backup Database_B to E:\SQL\Backups\Full\Database_B\Database_B_20080906.BAK

    Backup Database_C to E:\SQL\Backups\Full\Database_C\Database_C_20080906.BAK

    Then copy the "FULL" folder to tape each night after the backups complete.

    There are about 100 ways to configure your backups & jobs, and they can all be "correct" ... depends on your preferences, business needs, convenience, server configurations, storage space .....

    As you can see from many postings over the years, there are also 100s of ways to mess up your backups.

  • September 9, 2008 at 9:14 am

    #869117

    Its sounds like, safe to keep in it seperately rathar than taking some chance.

    Even I choose to have difference files, just had a doubt.

    Thanks for your reply

    Regards,

    Mohanraj Jayaraman

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

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