HPE Community
HPE 3PAR StoreServ Storage
1751972 Members
5179 Online
108784 Solutions
New Discussion

How and what to verify to ensure the health of SQL Server after the Server migration using SAN

 
SivaOra
Occasional Contributor

‎03-21-2017 04:54 AM - edited ‎03-21-2017 05:03 AM

‎03-21-2017 04:54 AM - edited ‎03-21-2017 05:03 AM

How and what to verify to ensure the health of SQL Server after the Server migration using SAN

Hello There,

When the SQL Server Instances in  "A" Data Center are migrated to "B" Data Center, using the HP StorageWorks MPX200 Applicance , to transfer the data between the 3PAR SAN Storages.

Let me know what need to be tested after this data replication .

To ensure the Health and Readiness of the SQL Server instacnes, what need to be validated?

Like, SQL Server Services, database status, conenctivity.

Thanks, SivaOra

0 Kudos
Reply
2 REPLIES 2
yapkl
Trusted Contributor

‎03-21-2017 06:38 AM

‎03-21-2017 06:38 AM

Re: How and what to verify to ensure the health of SQL Server after the Server migration using SAN

AFAIK, there is nothing on storage level for you to do this. You could try SQL DB level checks.

Best Regards,

yapkl

Note: The opinions & comments above are my personal opinions, not of Hewlett Packard Enterprise
----------
If my post was useful, click on my KUDOS! thumb below! Thanks.
0 Kudos
Reply
SivaOra
Occasional Contributor

‎03-21-2017 09:07 AM

‎03-21-2017 09:07 AM

Re: How and what to verify to ensure the health of SQL Server after the Server migration using SAN

Hello yapkl,

 

Can we ask the SAN Administrator (3 PAR) , to provide any report or data to verify that data copy are in tact ?

 

Thanks, SivaOra

0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.