SQL Stuff

Shrink log files

Reset sa password

From command prompt

osql -L

Copy full name of SQL Server and type:

OSQL -S <insert_servername_here> -E

Execute the following query:

sp_password NULL, '<insert_new_password_here>', 'sa'

From SQL Management Studio

Using SQL Password Recovery Tool

When You Have SA Disabled

sqlcmd -m

Set RAM limits to internal SBS database


Error: SQL Server does not exist or access denied.

What tripped me up was that I was working with a non-default instance (original one was disabled). Apparently, the non-default instance gets a random port generated for it. Also, the port doesn’t seem to show itself anywhere in the SQL management tools.

The port was found here: