November 26, 2008 at 5:59 am
I've got a standalone server where the data drive is nearing capacity. Space has been made available on the SAN. I'm using SQL Server 2005. I've got a couple of questions.....
1. Should I use mount points or drive letters on the SAN? I was reading on BOL about mount points as a consideration if you're in a clustered configuration. Because this is a standalone server, I'm thinking a drive letter is appropriate. Any other thoughts?
2. In the standalone configuration, we have a drive that's partitioned into a C and D drives. The C drive has the OS and the D drive holds the data. Should the SAN be setup like this where the OS is on a C (SAN drive) and the data on a D (SAN drive)?
3. Last one.....in the standalone configuration the database backups are saved to a backup folder on the D drive. Should that configuration continue when the data is moved to the SAN--with both databases and backups residing on the same SAN drive?
Thanks in advance for your help!
November 26, 2008 at 7:24 am
Hi,
1. Mountpoints are good if you are running out of drive letters so to speak. This is more likely on a cluster because SQL Server instances cannot share the same disk(s) in a cluster - in a non-clustered environment all your SQL Server instances can use the same disk(s).
2. You would still keep your OS on the local drive, wouldn't you? Otherwise you will have to boot from the SAN.
3. If disk space and performance is an issue on the local D drive; move the backups to the SAN as well (assuming the performance is better). However, because there is also a Disaster Recovery aspect, you might want to keep them on the local drive; your data is on the SAN and you don't want to put all your eggs in the same basket (if the SAN fails, your backups are still available if it is on the local drive).
HTH
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
November 26, 2008 at 8:49 am
I like Elizabeth's advice, especially about backups. I might put them on the SAN IF I was sure they were on physically separate disks, but you want to make sure if the data is lost, the backups are still around.
SANs failing, it can happen, but you might not be able to get enough hardware in place to rebuild a server anyway without getting the SAN working. Hasn't been a big concern and many people don't buy one SAN, they buy two.
I would still make sure my backup files were being pulled to tape or another server as well.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply