Paths not well defined for databases

  • What are the potential risks of keeping data , log , tempdb backups etc in the same drive although in different folders ?

  • Potential risk

    worst case, total drive filaure results in End of the world

    Best case , severe performance issue when read and write operations and backups are being performed all the time.

    🙂

    Jayanth Kurup[/url]

  • There is also the hidden same drive scenario also.

    Is the drive split into multiple partitions? EG a 500GB drive split 250GB / 250GB labeled with different drive letters. Although you have separated them onto what you think are two different drives it's not. Loose that drive you've lost both partitions.

    Is the storage SAN storage, how have the disks been mapped? are they all part of the same RAID group, depending on the RAID level, you could end up loosing it all also. Multiple disks mounted from LUNs over the same RAID group look like single disks to the OS, but to the SAN its one big pool. If the RAID group is RAID5, loose 1 disk your fine, loose 2 end of the world.

  • muzikfreakster (10/29/2015)


    What are the potential risks of keeping data , log , tempdb backups etc in the same drive although in different folders ?

    It all depends on how the volume(s) are setup.

    Mounted volumes employ exactly this design, they use a root drive which has mount folders created, separate volumes are then mounted underneath these folders, for more on mounted volumes see my article at this link[/url]

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

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

  • It's easy to forget, but drives can, and do, fail. Sometimes they become so damaged/corrupt they cannot be read. If that happened, obviously you would lose all your data, including all backups. That would be very bad.

    At the very least you should keep the db files and backups on different drives. Then if either drive fails, you can still recover the data.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

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

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