Recently, I was assigned to a project – our customer purchased a new SAN, and they wanted us to replace the old one with a new SAN. User and system databases utilized SAN, meanwhile, the operating system and SQL were installed on the server’s local disks. Lucky us..!! The idea was to move the existing user and system databases to a new SAN and keep the downtime as minimum as possible. So, to minimize the downtime, instead of reinstalling OS and SQL, we decided to use the following approach.
- Attach a new SAN to an existing server, create new drives on it, and add those drives to an existing failover cluster instance.
- Stop SQL Server, copy master, model, and msdb databases on new drives and start the SQL services.
- Move User databases to new drives and remove the old SAN.