Application validation after moving to SQL 2019

Question

Application validation after moving to SQL 2019

sns 9,241

We need to validate the SharePoint application after moving to new cluster of SQL nodes with version of 2019

Please see below where windows and storage team will be performing activities, with yellow color SharePoint ( I am ) need to perform

Please suggest.

I am not sure 7th row , how they are performing migration, ( might be database backup)

what exactly I need to validate here?

After backup and restore ( migration ) do I need to dismount and mount?

How do I validate from my end as a SharePoint admin?

I feel they have not provided full infomation on this request and also they have not informed how they are migrating? is it below information enough ?

what are the things that I need to check from SQL team on this? Please confirm

Xyza Xue_MSFT 29,441 Reputation points Microsoft External Staff

2023-02-15T02:56:57.3866667+00:00

Hi @sns ,

Do you want to migrate the data to the new cluster or update the old cluster to the new version? Please provide details of what you want to do and the specific steps to do it.

If there are no specific operation steps, please specify the SQL aspect, what you want to do, the specific situation of the current environment, and what specific effect you want to achieve?
sns 9,241 Reputation points

2023-02-15T11:43:13.7733333+00:00

Hi Haoyan Xue,

We are migrating data to new cluster.
Xyza Xue_MSFT 29,441 Reputation points Microsoft External Staff

2023-02-17T02:24:25.84+00:00

Hi @sns ,

In order to better solve your problem, I suggest you describe the problem in detail, and what effect do you want to achieve in the end? Please answer the following questions:

Please provide details of what you want to do and the specific steps to do it.

If there are no specific operation steps, please specify the SQL aspect, what you want to do, the specific situation of the current environment, and what specific effect you want to achieve?
Xyza Xue_MSFT 29,441 Reputation points Microsoft External Staff

2023-02-21T09:11:34.5066667+00:00

Hi @sns ,

I am checking the status of this case. Please let us know if you would like further assistance.
If you have any update about this issue, please feel free to post back.
sns 9,241 Reputation points

2023-02-21T17:30:41.8233333+00:00

Hi Haoyan Xue,

Thank you for the response.

Even I am not sure , so I just got the above information, I will let you know further.
sns 9,241 Reputation points

2023-02-23T06:35:00.9733333+00:00

Hi Hayon Xue,

THey have changed from old to new node which is SQL 2019 , how do we validate SharePoint from our end.? it is done now, I can see CA and timer service are running fine, do i need to check anything further?

second question:

is there any command that I can check that whether SP server is connecting to new SQL node? Please confirm

Please provide me commands and also please let me know in which server i should check

and I tried to check by creating UDL file in the SHarepOint server in the desktop but not sure why it is giving below errror, I tried to follow below blog

https://www.c-sharpcorner.com/blogs/creating-udl-to-test-the-connection-between-sharepoint-and-sql
sns 9,241 Reputation points

2023-02-23T09:31:35.9133333+00:00

test123

1 answer

Your answer

Xyza Xue_MSFT 29,441 Reputation points Microsoft External Staff

2023-02-15T02:56:57.3866667+00:00

Hi @sns ,

Do you want to migrate the data to the new cluster or update the old cluster to the new version? Please provide details of what you want to do and the specific steps to do it.

If there are no specific operation steps, please specify the SQL aspect, what you want to do, the specific situation of the current environment, and what specific effect you want to achieve?
sns 9,241 Reputation points

2023-02-15T11:43:13.7733333+00:00

Hi Haoyan Xue,

We are migrating data to new cluster.
Xyza Xue_MSFT 29,441 Reputation points Microsoft External Staff

2023-02-17T02:24:25.84+00:00

Hi @sns ,

In order to better solve your problem, I suggest you describe the problem in detail, and what effect do you want to achieve in the end? Please answer the following questions:

Please provide details of what you want to do and the specific steps to do it.

If there are no specific operation steps, please specify the SQL aspect, what you want to do, the specific situation of the current environment, and what specific effect you want to achieve?
Xyza Xue_MSFT 29,441 Reputation points Microsoft External Staff

2023-02-21T09:11:34.5066667+00:00

Hi @sns ,

I am checking the status of this case. Please let us know if you would like further assistance.
If you have any update about this issue, please feel free to post back.
sns 9,241 Reputation points

2023-02-21T17:30:41.8233333+00:00

Hi Haoyan Xue,

Thank you for the response.

Even I am not sure , so I just got the above information, I will let you know further.
sns 9,241 Reputation points

2023-02-23T06:35:00.9733333+00:00

Hi Hayon Xue,

THey have changed from old to new node which is SQL 2019 , how do we validate SharePoint from our end.? it is done now, I can see CA and timer service are running fine, do i need to check anything further?

second question:

is there any command that I can check that whether SP server is connecting to new SQL node? Please confirm

Please provide me commands and also please let me know in which server i should check

and I tried to check by creating UDL file in the SHarepOint server in the desktop but not sure why it is giving below errror, I tried to follow below blog

https://www.c-sharpcorner.com/blogs/creating-udl-to-test-the-connection-between-sharepoint-and-sql
sns 9,241 Reputation points

2023-02-23T09:31:35.9133333+00:00

test123

Answer 1

Xyza Xue_MSFT 29,441 Microsoft External Staff

Hi @sns,

I tested it according to the documentation you provided, and it works as described in the documentation without any problems.

User's image

The error reported in your screenshot should be that there is a problem with the .UDL file you created, please check the following steps:

1.Create a new empty Text Document

2.Save As Test.UDL and Select All files in Save as type. User's image

3.Double-click Test.UDL to open the file for testing.

In addition, you can also check SQL Server Connectivity from SharePoint via powershell , please refer to:

https://www.sharepointdiary.com/2014/08/how-to-check-sql-server-connectivity-from-sharepoint.html

(New-Object System.Net.Sockets.TCPClient("SQL-Server-Name",1433)).Connected

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

sns 9,241 Reputation points

2023-02-23T09:53:18.5966667+00:00

Hi Hayon Xue,

Thank you for the response.

Please suggest
sns 9,241 Reputation points

2023-02-23T11:04:37.6433333+00:00

thankss
sns 9,241 Reputation points

2023-02-27T04:23:13.0166667+00:00

Hi Haoyan Xue,

I just want to check, did you get chance to check my previous thread?
sns 9,241 Reputation points

2023-02-27T16:37:06.26+00:00

test123
sns 9,241 Reputation points

2023-02-27T16:38:04.5866667+00:00

Hi Hayyun Xoe,

Did you get a chance to look above thread?

Share via

Application validation after moving to SQL 2019

1 answer

Your answer