We have a database server configured in RAID 5 and 1.
All the data files are on a disk array which is configured in RAID 5. Now we need to expand the disk space to accomodate larger amount of data.We will be replacing the existing disks with larger capacity disks.
The steps involved will be as specified below.
1. STOP the SQL Server service
2. Load higher capacity HDD.
3. Reconfigure RAID level again
4. Put the data file & log file on the same drives as existing one i.e. :\...\ DBData.mdf and . F:\...\ DBlog.ldf
5. START the SQL Server Service
We also have replication set for the database. All the SQL Server installables and replication related folders are kept on C:\ which is a separate disk array. We will not touch this array during our activity.
Will this activity create any problem for replication when SQL Server is started again?