Breaking News
Loading...
Wednesday, 19 August 2015

Info Post

eMO Database Log Up normally grown. How to clear it

In Most of the offices after upgrading into Meghdoot v7.9.3 eMO database log files getting increased upnormally. Even we clear/shrink the database it will be increased automatically.

Follow the below instruction

  • Take eMO database backup.
  • Download and Execute the attached solution using script tool 
  • Run the below query in SQL query analyzer, the issue will be solved. 
USE eMO
GO
ALTER DATABASE eMO SET RECOVERY simple
GO
DBCC SHRINKFILE (eMO_log , 1)
Go
ALTER DATABASE eMO SET RECOVERY Full

Note: Apply the above solution with SA Concerned.

0 comments:

Post a Comment

:) :)) ;(( :-) =)) ;( ;-( :d :-d @-) :p :o :>) (o) [-( :-? (p) :-s (m) 8-) :-t :-b b-( :-# =p~ $-) (b) (f) x-) (k) (h) (c) cheer
Click to see the code!
To insert emoticon you must added at least one space before the code.