• Hi Gregory Jackson,

    Regarding SAN and NAS, we are facing a prd issue. Will u please help me out in this.

    Scenario:

    During design layout we have planned to create a table t1 (with 5 colums) 4 colums @ SAN and 1 Column Img1 and it related Indexes on NAS (Because this columns will hold the Image data).

    During the course of time, while this NAS went down, the cluster manager does the fail over from active / passive server. During the change over the fail over server cannot recognize the NAS was down. Due to this the prd applicaiton at 300 and more sites (24/7 operational database) cannot access the central server. Due to the Img1 Column sitting on NAS the SQL Server 2008 R2 cannot come up. This was a SEV1 ticket.

    To avoid the scenario i suggested the project to go for SAN.

    Now they have proivded SAN as well.

    My environment is using Merge and Transaction replication. There is no down time for this environment.

    The NAS Img1 Column in FileStreamGroup1.

    For trail run in Dev env:

    Created a New Table T2 and also created a New FileStreamGroup2 and set this as default.

    After populating the data from table t1 to t2, i cannot rename the table because it is in the replication env table.

    What is better solution.

    There is now way attach / detach / offline etc.,

    Thanks in advance

    Best regards

    Santhosh