Query to reduce the size of eMO database in SQL
So the following query was executed and the mdf file size was reduced to minimum ie. 1 gb. Pls circulate dis among our friends.
Note:Applicable to SQL Server 2008.
USE eMO
GO
ALTER DATABASE [eMO] SET
RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE ([eMO_log], 1)
ALTER DATABASE [eMO] SET
RECOVERY FULL WITH NO_WAIT
GO
0 Comments: