Friday, October 19, 2018

MSSQL - Fixing Transaction Log backups failing with error "@@SERVERNAME does not match SERVERPROPERTY('ServerName')"

To Fix Transaction Log backups failing with error "@@SERVERNAME does not match SERVERPROPERTY('ServerName')" you can simply run the following to verify that the machine name and server name property are the same:


SELECT SERVERPROPERTY('MachineName')
SELECT @@SERVERNAME


If not, you must fix it manually and RESTART SQL - replace oldname and newname with the new name of the SQL server.

sp_dropserver 'OLDNAME;
GO
sp_addserver 'NEWNAME', local;
GO

No comments:

Post a Comment

TIP 0005: Test bad SSL

This is a tool for testing "memorable site for testing clients against bad SSL configs" https://badssl.com/