Category
SQL Server
25 articles · Page 3
-
VMware VirtualCenter Server service does not start automatically after reboot
We had a problem with our VMware VirtualCenter Server service which did not start automatically after a server reboot. This could be a problem when the VMware VirtualCenter Server service starts before the MSSQL Server. Now…
-
Hardware, Hosting, Microsoft, Microsoft Azure, School, SQL Server, Visual Studio, Windows, Windows Server
Microsoft WebMatrix and Microsoft WebPlatform Installer
For a project at KTSI we needed a platform to quick deploy PHP and MySQL applications. There are a lot of solutions out there in the web, for example XAMPP. After testing some options I had a…
-
How to integrate (slipstream) SQL Server 2008 and SP1
To install SQL Server 2008 on a Windows Server 2008 R2 you need a slipstream version of SQL Server 2008 with integrated Servicepack 1. At the moment you can’t download SQL Server 2008 with integrated SP1,…
-
Shrinking the Transaction Log in SQL Server 2005
Shrinking the Transaction Log in SQL Server 2005 Use the MS SQL Server Management Studio EXEC sp_dboption ‘XXX’, ‘trunc. log on chkpt.’, ‘TRUE’ CHECKPOINT DBCC SHRINKFILE (‘XXX_Log’, TRUNCATEONLY) EXEC sp_dboption ‘XXX’, ‘trunc. log on chkpt.’, ‘FALSE’…
-
Shrinking the Transaction Log in SQL Server 2000
Here is how you Shrinking Transaction Log SQL Server 2000: Use the SQL Query Analyzer BACKUP LOG XXX WITH TRUNCATE_ONLY GO DBCC SHRINKFILE(XXX_log, 10) GO (replace XXX with the database name)
