By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,278 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,278 IT Pros & Developers. It's quick & easy.

arbitrarily delete transaction log

P: n/a
Question: (SQL Server 2000) Can I arbitrarily delete a transaction log
file in either bulk or full with a cron job and still be able to
restore a backup? Or are the log and the .bak enmeshed to the extent
that this not do-able?

Details: I need to exclude a file group from a backup as it's static
data and replicated on a remote server. In order to do this I cannot
use a simple recovery model which I currently use; at least in the GUI
the exclude filegroup option is grayed-out. So it appears I need to use
either bulk or full backups although I only need the functionality of
the simple model.

Is there another way to delete/truncate this transaction log without
making a backup? Or can I just schedule backup through the day to
handle this issue?

Obviously I am not a DBA but still need to solve this problem.

Thanks,
Phil

Dec 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi

If you are lucky you can, BUT it is not supported do delete the log's file.

You may end up with a corrupted DB, so you would really be screwed.

The correct way is to make a log backup before you take a full backup.
Ideally, you should take log backups frequently during the day otherwise
point in time recovery will be very difficult to attain.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mi**@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

<pl**********@gmail.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
Question: (SQL Server 2000) Can I arbitrarily delete a transaction log
file in either bulk or full with a cron job and still be able to
restore a backup? Or are the log and the .bak enmeshed to the extent
that this not do-able?

Details: I need to exclude a file group from a backup as it's static
data and replicated on a remote server. In order to do this I cannot
use a simple recovery model which I currently use; at least in the GUI
the exclude filegroup option is grayed-out. So it appears I need to use
either bulk or full backups although I only need the functionality of
the simple model.

Is there another way to delete/truncate this transaction log without
making a backup? Or can I just schedule backup through the day to
handle this issue?

Obviously I am not a DBA but still need to solve this problem.

Thanks,
Phil

Dec 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.