Question about Sybase Adaptive Server Enterprise for Mac OS X 12.5

1 Answer

SYBASE 12.0 WHEN LOG IS FULL THEN WHAT CAN I DO?

Dear sir,

 

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

thanks

sushant

Posted by hant on

Ad

1 Answer

Anonymous

  • 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

Regards,
Rajini 

Posted on Oct 29, 2007

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How many Gb?


5Gb to 20Gb for RAM. 60Gb to 5 Terabyte for Hard Drives.

Sep 20, 2015 | Computers & Internet

Tip

Chkdsk.exe


check hard disk health
Check Disk - check and repair disk problems
goi to run type cmd in run, open cmd as administrator

TYPE

CHKDSK [drive:][[path]filename] [/F] [/V] [/R] [/L[:size]]
Key
[drive:] The drive to check.

filename File(s) to check for fragmentation (FAT only).

/F Automatically Fix file system errors on the disk.
/X Fix file system errors on the disk, (Win2003 and above)
dismounts the volume first, closing all open file handles.

/R Scan for and attempt Recovery of bad sectors.

/V Display the full path and name of every file on the disk.

/L:size NTFS only: change the log file size to the specified number of kilobytes. If size is not specified, displays the current log size and the drive type
(FAT or NTFS).
/C Skip directory corruption checks.
/I Skip corruption checks that compare directory entries to the
file record segment (FRS) in the volume's master file table (MFT)Example:

on May 20, 2010 | Computers & Internet

1 Answer

Is it possible to Repair DBF file?


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

http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/593-foxpro-behavior-when-opening-dbf

and even try to program DBF Recovery Kit

http://www.all-recovery-inc.com/#!/foxprorecovery

Dec 02, 2014 | Microsoft Visual FoxPro Professional...

1 Answer

Duracell 32GB USB says it's filled up even after I've deleted everything...


Try re-formatting the whole drive and make sure the partition size is 32gb!

Nov 02, 2012 | Duracell New- DU-ZP-32G-CA-N3-C CAPLESS...

1 Answer

Upgrade Iriver h10 20gb with V2.51firmware


Go here:
http://www.iriver.com/index.asp?code=0302
...and search for H10; look for the correct configuration for your unit in the small-font listing under [MTP] H10 5GB/6GB/20GB Firmware V2.51 - US & EU (which is probably H10_20GC_ENG_MT.ZIP if you're in the US).
Then search the site for Firmware Updater. Dowload it, unzip it, and run iriver Firmware Updater Setup.exe. Follow the steps on the screen. You might lose your data and have to reload all of it back onto the player, though. Good luck!

Jan 15, 2010 | iRiver H10 MP3 Player

1 Answer

How to check size of log file ?


Sir
check the below links and go through the site
link 1
link 2
Thanks Good Luck
Appreciate to rate as "Fixya"

Jun 12, 2009 | Microsoft Visual Basic Enterprise Edition...

1 Answer

Lenovo T61 87GB hard drive is full and shouldn't be.


Hi,
Delete temp files, if no temp files, check the disk management whether disk is configured correctly or not.

Mar 15, 2009 | Lenovo ThinkPad R60 with Wireless Wide...

1 Answer

The size of squid log files of my proxy server are geting too big for my disk space. I manually deleate them when the disk space is gettin full & the squid service is stoped autometically.How can I delete...


Find your squid.conf file. Likely path to it could be /usr/lib/squidc/etc, or
maybe /etc/squid.

That file should contain a setting for logfile_rotate, probably at a default of
10. Change that to 2.

Then add a once-a-day job to root's crontab, on the order of:
1 1 * * * /usr/lib/squid/bin/squid -k rotate

Mar 03, 2008 | Computers & Internet

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

Related Topics:

980 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sybase Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Marvin
Marvin

Level 3 Expert

85231 Answers

Brad Brown

Level 3 Expert

18204 Answers

Are you a Sybase Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...