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
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Aug 24, 2016 | Computers & Internet
Mar 20, 2015 | Computers & Internet
Jan 18, 2011 | Intuit QuickBooks Pro 2010 Full Version...
Jan 05, 2010 | Apple 12" iBook G3 700Mhz with 256 RAM,...
Oct 24, 2009 | Dell Dimension 4600 PC Desktop
Aug 06, 2009 | Envision EN-910e 19 in.CRT Conventional...
Apr 12, 2009 | Computers & Internet
Mar 03, 2008 | Computers & Internet
977 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: