Backup Analyzer fails if value returned from SELECT @@SERVERNAME does not match machine name
Steps to Reproduce:
1. install sql server with a default instance, install 5.0.0.10668
2. After installing sql server, rename your computer (reboot)
3. Open the LiteSpeed UI, select a database and choose backup analyzer
4. Run a new test and it will fail with the attached error (see error log and email)
The reason is that @@SERVERNAME returns the name different from actual instance name.
Get the value from SELECT @@SERVERNAME
EXEC sp_dropserver '<current servername>'
EXEC sp_addserver '<result from the SELECT @@SERVERNAME>, 'local'
After running these procedures you need to restart the SQL Server.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center