Question about Sybase Adaptive Server Enterprise for Mac OS X 12.5

1 Answer


Dear sir,


my databse size is 20gb, my log file size 5gb, my log file is full then what i do?



Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Hi Sushant,

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

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

2 Answers

Attach a database without the corrupted log file

There might be other options out there. This is something that worked for me once but there are no guarantees that it will work at all times.

Stop SQL Server instance -> Copy MDF and LDF files to another location -> Delete original MDF and LDF files -> Start SQL Server instance again -> Create new database with exact same name and file names -> Stop SQL Server -> overwrite newly created MDF and LDF.

After this your database should be back online. If it is then go ahead and put it into EMERGANCY mode and SINGLE USER mode.

Finally go ahead and execute DBCC CHECKDB like this


More information you can dig out from resources directly connected with SQL Server databases and database corruption in MS SQL Server any version... SQL Server Repair Toolbox

May 15, 2015 | Microsoft SQL Server 2008 Enterprise Full...

2 Answers

SQL 2008 R2 - MASTER.LDF corrupted without backup

Try this one solution...

1. First Shutdown SQL Server
2. Then move the current database file/rename (do not touch the .ldf)
3. After rename/move db, restart SQL Server
4. Create a new database with same name and log file and location also same
5. Stop SQL Server

Make use of some interesting links which might help you.... - a lot of guides and tips for corrupted sql server databases Recovery Toolbox for SQL Server - free demo version of this tool, if any variant doesn't seem effective

Apr 26, 2015 | Microsoft SQL Server 2008 Enterprise Full...

3 Answers

Is it good idea to repair sql file?

Bulk Logged will not help you in this situation. Your transaction log is growing because you are performing large transactions. In simple mode, the log is truncated after a checkpoint.
Check these site: & download demo Recovery Toolbox for SQL Server.
Depending on how you are loading your data, you may need to break it up into smaller chunks. Make sure you are not loading all the data in one large transaction.
Read more:

Nov 06, 2014 | Microsoft SQL Server 2005 Standard Edition

2 Answers

I can't send emails with attachments using outlook 2007

Please check the size of the attachments and the extension of them. Outlook does not allow any .exe or any programs as an attachment.

Apr 29, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

Word and Excel items are not addes to the log in Outlook

I haven't used the logging feature on my outlook, but here are a couple of links that may prove helpful. Microsoft and MyFavOutlookTips

I hope this information allows you to resolve this issue. If you need further assistance, please post back with a comment to this thread. If I've managed to answer your question or solve a problem, please take a moment to kindly rate this post....thanks!

Apr 01, 2009 | Microsoft Office Word 2007 Full Version...

Not finding what you are looking for?
Sybase Adaptive Server Enterprise for Mac OS X 12.5 Logo

Related Topics:

970 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sybase Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18257 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Sybase Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides