January 24, 2012 at 2:53 pm
Our SQL Backups, SQL Data, SQL Integrity, and SQL Optimization folders are on an E: drive.
This E: drive is part of an ISCSI disk group configuration.
We need to move these SQL items to another ISCSI disk group. Here is what we are thinking:
1. SQL Server will be offline/shutdown during this switchover.
2. Copy the contents of this drive to the 'new' drive, which is the same size.
3. Unmap the current E: drive from the computer.
4. Map the 'new' drive, as E: to this computer.
5. Start SQL Server.
Sounds like it will work OK, ...
Will this change be transparent to SQL Server and will it run OK, not knowing the physical hard drive was changed? Or might there be something in the background on SQL Server (that's not apparent to us) that will cause the switch over to fail?
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
January 24, 2012 at 3:08 pm
There should be no issues as long as all references are via that mapped drive letter.
The probability of survival is inversely proportional to the angle of arrival.
January 25, 2012 at 6:16 am
Thanks for the reply. Good point. I checked the Maintenance Plan entries - they reference E:It was good to get this information, a tidbit for future checklists - I learned a little bit more.
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply