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
A 6ya expert can help you resolve that 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.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Aug 24, 2016 | Computers & Internet
on May 20, 2010 | 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
Apr 24, 2018 | Individual Computers & Internet
976 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: