When running the Backup Analyzer on any database, the following error is displayed:
Cannot insert the value NULL into column "ServerName', table 'LiteSpeedLocal.dbo.LiteSpeedDatabase'; column does not allow nulls. INSERT fails.
Cannot insert the value NULL into column "ServerName', table 'LiteSpeedLocal.dbo.LiteSpeedAnalyserTests'; column does not allow nulls. INSERT fails.
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 error above.
1. Open a query analyzer and confirm the existing server name value;
SELECT SERVERPROPERTY('SERVERNAME') or SELECT @@SERVERNAME
2. Run the command below to add the correct server name.
Use Master
go
Sp_Addserver 'your instance name', 'local'
GO
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy