Question about Sybase Adaptive Server Enterprise for Mac OS X 12.5
my databse size is 20gb, my log file size 5gb, my log file is full then what i do?
If your database log gets filled. You can alter the log size if required in future too. If the log suddenly got filled and it is not occuring everyday then you have to find which query causing the log filled by executing the below
select * from syslogshold where dbid=db_id("your db name")
find out the spid and then run sp_showplan and dbcc sqltext for the particular spid and then decide upon the query whether you can stop(kill the process) it or allow it run by increasing the log space.
Be careful in production environment. Don't it kill any process without confirmation of user.
If the same query is running everyday and log is getting fill everyday then you can alter the database log space with proper approval.
If the same query is running everyday but today only log space got fill then check the growth of data decide accordingly log size of your database.
I hope this will help you if log got filled.
All the best
Posted on Oct 29, 2007
Tips for a great answer:
on May 20, 2010 | Computers & Internet
If the file needs to be repaired, it is already damaged. To make things worse not only keeps a spare copy. And so - foxfix very powerful tool for recovery. Or a hex editor to see what is written in the tail of the file if the garbage - it cut before the "normal" data (aligned along the border post), to calculate the size and the size of the .dbf header records how many there really are, and to correct the record count in the header. Also there is a file header, which is similar to can (and should) rule in heh mode.
here you can see this topic. Here is the link to the forum
and even try to program DBF Recovery Kit
Dec 02, 2014 | Microsoft Visual FoxPro Professional...
Nov 02, 2012 | Duracell New- DU-ZP-32G-CA-N3-C CAPLESS...
Jan 15, 2010 | iRiver H10 MP3 Player
Mar 15, 2009 | Lenovo ThinkPad R60 with Wireless Wide...
Mar 03, 2008 | Computers & Internet
Try to re formatt the hard drive.
Apr 27, 2007 | JVC Everio 25x/20GB Hard Disk Drive...
980 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: