SQL Server Error Msg 49972 – Cannot add tempdb remote file to local tempdb filegroup in transition to primary

In this blog post, let’s learn about the error message “49972 – Cannot add tempdb remote file to local tempdb filegroup in transition to primary.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

49972 – Cannot add tempdb remote file to local tempdb filegroup in transition to primary.

Reason for the Error

The SQL Server error 49972 occurs during the transition of a database to primary, and it indicates that SQL Server is unable to add a tempdb remote file to the local tempdb filegroup. Here are some of the possible causes of this error:

1. Insufficient disk space: SQL Server may not be able to add the tempdb remote file to the local tempdb filegroup due to insufficient disk space on the server.
2. Lack of permissions: The SQL Server service account may not have the necessary permissions to add the tempdb remote file to the local tempdb filegroup.
3. Connectivity issues: There may be connectivity issues between the server where the tempdb remote file is located and the server where the local tempdb filegroup is located.
4. The tempdb file is full: The tempdb file may be full, preventing SQL Server from adding the tempdb remote file to the local tempdb filegroup.

Solution

To fix this error, you can try one of the following solutions

1. Ensure that there is sufficient disk space on the server where the local tempdb filegroup is located. You can also try removing unnecessary files from the server to free up space.
2. Check the permissions of the SQL Server service account to ensure that it has the necessary permissions to add the tempdb remote file to the local tempdb filegroup.
3. Verify the connectivity between the server where the tempdb remote file is located and the server where the local tempdb filegroup is located. Check for any network issues that may be causing the connectivity problems.
4. Check if the tempdb file is full. You can use the DBCC SHRINKFILE command to shrink the tempdb file, or you can add additional tempdb files to the local tempdb filegroup to increase the available space.