Author: actsupp-r0cks

Shrink 2008 MSSQL database

Shrinking SQL 2008 database is nowhere related to SQL 2000/2005 Method. Because SQL Server 2008 no longer allows you to truncate the transaction log using the no_log syntax But here is the special code to shrink the database: USE MASTER GO ALTER DATABASE database_name SET RECOVERY SIMPLE GO USE database_name GO DBCC SHRINKFILE (database_name_log, 1) […]

Continue Reading

SQL Server Port

Scenario 1: SQL is not connecting via Management studio locally after a fresh Installation: 1. After a fresh Installation of SQL  and opening the port in the Firewall you may not be able to connect via SQL management studio. Note: Installing SQL and opening the port in Firewall will not listen to the service/port. Its […]

Continue Reading