Archive for the ‘Microsoft SQL’ Category

How to truncate and shrink Transaction Log file in SQL Server 2008 R2

Friday, July 27th, 2012
select name,recovery_model_desc from sys.databases
GO
Alter database DATABASENAME Set Recovery simple
GO
Declare @LogFileLogicalName sysname
select @LogFileLogicalName=Name from sys.database_files where Type=1
print @LogFileLogicalName
DBCC Shrinkfile(@LogFileLogicalName,100)
 
 

Completely Remove SQL 2005

Saturday, October 24th, 2009
1) Stop all SQL Services.
2) Uninstall all Microsoft SQL services in Control Panel
3) Delete all files in %Program Files%\Microsoft SQL Server directory
4) Open REGEDIT32 and delete key “HKCU\Software\Microsoft\Microsoft SQL Server”
5) Open REGEDIT32 and delete key “HKLM\Software\Microsoft\Microsoft SQL Server”

Use REGEDIT32 on your own risk.