Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smcsupport
Starting Member
1 Post |
 Posted - 2009-11-19 : 16:58:03
|
| I have an SQL 2005 instance (running on a Win2k3 server) that I need to move, because my server's onboard disk space is running out. I have purchased a disk array to attach to the server and need to figure out the most efficient way of moving the instance onto the new array, and off the onboard storage. Currently, the SQL instances are on their own volume.There are two ideas I want to check out as options:1. Shutting down all SQL services, moving all the data out of the instance folder, mounting a volume (from the array) to the instance folder, moving all the data back into the instance folder (and thus putting it on the array), and turning all the SQL services back on.OR2. Shutting down all SQL services, making a carbon copy of the data on my onboard SQL volume onto a new volume on the array, simply changing the drive letters around in Windows so the array owns the letter the onboard volume used to own, and then cutting the SQL services back on.In a parsimonious world, that would work; but we certainly don't live in a world like that :)I can see my plan not working if MS SQL Server 2005 uses GUID references or ARC path names for the partitions/disks. I'm concerned about the "unknown unknowns", given my limited experience as a DBA.Any help or advice you can offer this relative novice is much appreciated.Thanks. |
|
|
|
|
|
Instance Move and Volume Mount Points