Archive for the ‘Microsoft SQL’ Category
Microsoft® Update-katalog
Saturday, September 12th, 2020How 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, 20091) 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”
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.