Query to reduce the size of eMO database in SQL

Query to reduce the size of eMO database in SQL


When MDF of SQL database file grow and consume more space in the HDD and the MM Modules/SQL Management studios becomes unresponsive in  most of the times.In my case, emo mdf file size increased to 93 GB due to which the hard disk space was almost occupied by the eMO database file(MDF) file also we can't do any emo operation in the eMO module.

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

Popular posts from this blog

SOP - Postman Mobile Application-Android

Image
 SOP -  Postman Mobile Application-Android When you open the app after installing, the screen as shown  below appears. Please provide password. The default is  postman. After login, the postman will be provided the options to effect delivery of the following mail categories. Electronic Money Order, Speed Post, Registered Post, Parcel Post, Parcel COD, Bulk Delivery. The following are utility options to analyse delivery performance and tally account in case of eMO, COD articles etc. before submitting returns. Delivery Performance, Account, Barcode Scanner and Developer's Log The postman can select relevant options to deliver the mail items. For example to deliver the eMO he can click electronic money order icon. When Electronic Money Order is selected, all the eMO to be paid in the beat will appear as shown below. To pay the money order click take return option. This will bring the following screen which shows the details like article type, article no., name of the c...
Read more

Ten Ways to Help Your Customers Get Serious About Passwords

Image
Practice what you preach. This is one mantra many computer repair technicians live by. Yet one area that we’re still pretty hypocritical about is passwords. Be honest with yourself: are all of your credentials following the generally accepted rules  of password complexity? It’s admittedly a hard principle to live by, seeing as we are inundated with passwords for what seems to be every service we deal with. Our customers are in the same position, and the onus is on us as computer repair technicians to ensure that they have a sound password policy and are sticking to it. Computer security expert Steve Gibson covers password strength and complexity at length during his usual appearance on many  Security Now  podcasts. But he recently penned an excellent article for Consumer Reports magazine on some  common password creation tips  that he believes work well. He recommends that users employ password techniques such as complex passphrases or sentences. At t...
Read more