Category Archives: SQL Server Configuration

Unable to start SQL Server after relocating TempDB

After I modified the file size of tempdb database yesterday on my SQL Express instance, SQL Server was failed to start. When I checked the SQL Server error log, following entries were recorded. 2012-11-07 11:25:34.99 spid10s Error: 17053, Severity: 16, … Continue reading

Posted in How To, Just Learned, SQL Server, SQL Server Configuration, SQLCMD | Tagged , , , | 7 Comments

How to enable FILESTREAM features after installing SQL Server 2008?

It is possible to enable FILESTREAM after the SQL Server 2008 installation. Open the SQL Server Configuration Manager and select SQL Server Services. Right-click on the SQL Server Service, SQL Server (MSSQLSERVER), and select Properties from the available drop-down menu. … Continue reading

Posted in SQL Server Configuration | 1 Comment