Query to reduce the size of eMO database in SQL
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
Comments
Post a Comment