Post reply

Backup drives

  • October 1, 2008 at 3:01 am

    #125036

    Hi Guys,

    Would it be wise to backup a database to a drive where the data file resides and can a backup reside on the same drive as a log file?

    Regards

    IC

  • October 1, 2008 at 4:40 am

    #879384

    Data, log and backup can all reside on the same drive.

    Is is wise? NO!!!

    If you lose the drive, you have lost your data AND your backups

    Ideally, 3 separate disks... 1 for database, 1 for logs and 1 for backups... and make sure thay are physically different spindles, not just one disk partitioned into 3 drives or one large raid array carved up into 3 luns.

  • October 7, 2008 at 12:17 pm

    #881878

    And performance will be bad, especially if the Data & Log are on the same drive.

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

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