October 29, 2015 at 9:38 pm
What are the potential risks of keeping data , log , tempdb backups etc in the same drive although in different folders ?
October 30, 2015 at 1:48 am
October 30, 2015 at 2:34 am
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.
October 30, 2015 at 5:32 am
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" 😉
October 30, 2015 at 1:20 pm
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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply