Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transaction Log Backup-----Emergency Expand / Collapse
Author
Message
Posted Wednesday, June 17, 2009 5:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 11:30 PM
Points: 39, Visits: 241
Hi all,

I have two log files to my database one of 100MB and second of 1GB.

I scheduled backup of transaction logs for every 2 hours and it used to be only 50MB or some time 200MB.

But today it is something horrible.

I see the backup of transaction log as 1.2 GB or 1.3 GB for every 2 hours.

DBCC SELPERF(logspace) shows the rate on how it is increaing the logfile.

Anyone please help me.....its really very urgent


Will be verymuch thankful to you.........please
Post #736396
Posted Wednesday, June 17, 2009 5:40 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:52 PM
Points: 530, Visits: 1,134
Did you take a look on the activity that is going on the server.

Refer : http://www.sqlservercentral.com/redirect/articles/67120/


Thanks
Chandra Mohan
Post #736414
Posted Wednesday, June 17, 2009 5:49 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 8:07 AM
Points: 938, Visits: 1,142
A large logfile means something is running on your database. Did the full backup ran properly?
Check databaseactivity: Is the logfile still growing? There must be a process which is blowing up your logfile.


Wilfred
The best things in life are the simple things
Post #736424
Posted Wednesday, June 17, 2009 5:51 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 9:35 AM
Points: 2,223, Visits: 3,649
seems to me like there is huge data insert activity happening?
Or are you running maintainance plans(index rebuilds?)
for the moment, take backup of the log more frequently.

later when there is less activity on the system, you might want to shrink logs for once.





Pradeep Singh
Post #736426
Posted Wednesday, June 17, 2009 6:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 11:30 PM
Points: 39, Visits: 241
Part of all your replies helped me to analyse the issue.

There is an update statement running since yesterday.

Thank You to all
Post #736433
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse