• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1353
  • Last Modified:

sonicwall viewpoint 6 database shrink Mysql database

Hi,

want to reduce mysql database size used for sonicwall viewpoint logs and reports.

current database size is 90GB

Sonicwall help url options and commands not working

http://www.sonicwall.com/downloads/GMS_Maintenance_Procedures.pdf

https://www.fuzeqna.com/sonicwallkb/consumer/kbdetail.asp?kbid=4734


The raw syslog data in the RAWSYSLOGDB databases and in the [ViewPoint]\syslogs\archivedSyslogs folder will be deleted daily at the time specified at Console > Reports > Summarizer - ‘Delete Syslog Daily At’.  However, the space in the database is not reclaimed, so the following SQL must be run to remove white space and truncate the transaction log before the file size will more accurately reflect the amount of space used in the database:
 
(execute these statements one-by-one from a command prompt on the ViewPoint server)    
 
osql -U sa -P password -S IPaddress\SNWL -Q "use rawsyslogdb; DUMP TRAN rawsyslogdb WITH TRUNCATE_ONLY;”
osql -U sa -P password -S IPaddress \SNWL -Q "use rawsyslogdb; DBCC SHRINKFILE (rawsyslogdb _Log, 10);"
osql -U sa -P password -S IPaddress \SNWL -Q "use rawsyslogdb; DBCC SHRINKDATABASE (rawsyslogdb, 0);”      
 
                  Replace password with the password used during installation, and replace IPaddress with the IP of the ViewPoint server.
             Replace ‘rawsyslogdb’ with ‘sgmsdb’ in the OSQL above to shrink the SGMSDB database and truncate the transaction log.
 
above commands not accepting after login on mysql
kindly suggest.

Current MY SQL version showing 5.0.85
0
mash1978
Asked:
mash1978
  • 3
  • 3
1 Solution
 
Anthony PerkinsCommented:
Topic: MS SQL Server
You may get more response if you have this question moved to a more appropriate topic area, such as:
http://www.experts-exchange.com/Database/MySQL/
0
 
mash1978Author Commented:
not found any solution in this area
0
 
Anthony PerkinsCommented:
not found any solution in this area
No kidding.  Did I not just finish saying the same thing?  I suggest you delete this question and re-post in a more appropriate Topic area.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
mash1978Author Commented:
you are providing thousands of link and ask to search or find answer in this

We are not experts in database

so i will say thanks and good bye.. experts-exchange experts...
0
 
Anthony PerkinsCommented:
And I wish you the best of luck.
0
 
mash1978Author Commented:
no solution provided
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now