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


MS Sql Server LazyDBA home page