SQL Archives - LPM Automation

Microsoft SQL Servername does not match computer name

Posted on August 20, 2014August 30, 2014 by lpmautomation

Anyone who has downloaded any of the Microsoft Hydration kits of late looking to import them into their own lab especially in my case as SQL 2008 is becoming harder and harder to get hold of nowadays may of stumbled over just what I did today.

By renaming the machine and joining to my lab domain generated a warning in OpsMgr pre-req as machine name was different to when SQL was installed.

Quickly resolved in management studio by the following:

Confirm current name – select @@ServerName

Then execute the following statements.

Run Query from the SQL query window one statement at a time

sp_dropserver ‘old_server_name’
sp_addserver ‘new_server_name’, ‘local’

My Server required a reboot to pick up the changes!

Report Server DB SQL Server Error Log 9002 – ConfigMgr 2012

Posted on August 17, 2014August 30, 2014 by lpmautomation

Working at a client site this week after retuning for a health check I noticed that the SQL Server Log drive for SRS had consumed almost all of the disk available at 30GB!!!

Now as we know the logs for SRS should not be anywhere near that and trying to shrink down the available space proved fruitless as SQL was complaining about the disk being full. The auto grow was configured to consume all disk so this could not be amended easily.

As an Interim measure the recovery model on the database was set to Full which once changed to Simple allowed the database shrink to be implemented and corrected thus preventing SQL from consuming all of the disk.

Now the auto grow can be amended and if required recovery model reverted back to full.