RE: Urgent log file full issue

RE: Urgent log file full issue

 

  

Hi Robert, you can also go into Enterprise manager and right click the
database for whose log you want to truncate, go to All Tasks/Backup Database
select transaction log in the radio buttons and click the overwrite existing
media button then OK. This will accomplish the same thing as the script
command will.

If you have any questions or concerns, please let me know them.

Margaret Norkett
Database Administrator
* 864-271-6522 ext 222
* 864-270-2884




-----Original Message-----
From: Robert Jenkins
[mailto:mssqldba-ezmlmshield-x88916573.[Email address protected]
Sent: Thursday, December 28, 2006 9:32 AM
To: LazyDBA Discussion
Subject: RE: Urgent log file full issue

I guess I'm having a brain fart, but I keep getting a syntax error when
I try to run the "Backup LOG dev500_app" It gives the following error:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'dev500_app'

Also, the log file is 13.4 gig. We only have about 2.5 gig free. Will
this eat up the rest of the disk space and cause the server to crash?

Thanks again! :-)

RJ

-----Original Message-----
From: Mlynar Edward
[mailto:mssqldba-ezmlmshield-x93248050.[Email address protected]
Sent: Thursday, December 28, 2006 9:05 AM
To: LazyDBA Discussion
Subject: RE: Urgent log file full issue

Yes, it will only affect the log. The file size will remain the same.
This will free up space in the log.

Performing a full backup will also truncate the log. If you are having
problems with your log file filling up a lot, then backup the database
daily. If that's not possible, then schedule a transaction log backup to
occur throughout the day. You can use the maintenance wizard to do this
(if you're into that sort of thing) or you can use the BACKUP LOG
command without the truncate_only option.


Ed Mlynar
Database Administrator
Catholic Health East IT Shared Services
Email: [Email address protected]
Phone: 610-567-5377

-----Original Message-----
From: Robert Jenkins
[mailto:mssqldba-ezmlmshield-x19711429.[Email address protected]
Sent: Thursday, December 28, 2006 8:58 AM
To: LazyDBA Discussion
Subject: RE: Urgent log file full issue

This will only affect the log file and not the actual .mdf file? I read
about this command, but Microsoft can be pretty vague sometimes! :-)

-----Original Message-----
From: Mlynar Edward
[mailto:mssqldba-ezmlmshield-x20313040.[Email address protected]
Sent: Thursday, December 28, 2006 8:57 AM
To: LazyDBA Discussion
Subject: RE: Urgent log file full issue

backup log {database name} with truncate_only

ex: backup log tempdb with truncate_only



Ed Mlynar
Database Administrator
Catholic Health East IT Shared Services
Email: [Email address protected]
Phone: 610-567-5377

-----Original Message-----
From: Robert Jenkins
[mailto:mssqldba-ezmlmshield-x28859527.[Email address protected]
Sent: Thursday, December 28, 2006 8:54 AM
To: LazyDBA Discussion
Subject: Urgent log file full issue

Hello everyone, hope all have had a wonderful holiday season so far. I
am in dire need of some guidance. I need to empty the transaction log
without affecting users in a live environment, is this possible?
Please, any advice would be greatly appreciated.



RJ



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

MS Sql Server LazyDBA home page