December 21, 2006 at 10:20 am
Good afternoon. We will be installing our SAN system within a week or so, and I just had a few questions about connecting our SQL servers to the SAN. Would my outline below work?
1. Connect SAN to SQL server
2. Copy pertinent files (data, log, temp, backups, etc.) to SAN
3. Disconnect SQL server from domain
4. Disconnect current drives from SQL server
5. Create partitions on SAN, with the same names as the local drives had on SQL server
6. Copy files from SAN into partitions created
7. Re-connect SQL server to domain
Would this outline work to relieve us having to edit SQL jobs and DTS packages that reference drive names? Any thoughts would be greatly appreciated. Thanks.
Chris
December 21, 2006 at 1:21 pm
you would be better off changing the sql jobs to not look at a drive letter. try creating a share on a drive use the $ after the share so it is not seen by everyone, then chnage all your jobs to use the share. That way when this happens again or you move it to another server you will not have to try to maintain a drive name.
December 21, 2006 at 1:21 pm
I think you have things a little out of order.
I'm not sure you need to disconnect from the domain, but wouldn't you create all the partitions and copy the files, then just rename the drive letters?
December 21, 2006 at 1:25 pm
Steve you are correct - you need to assign a drive letter to connect the SAN to the server - or atleast to have it accessable
December 21, 2006 at 1:50 pm
Thanks for the input, guys. Steve, I found your resolution a little later on. Thanks again.
Chris
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply