Reply to Re: arbitrarily delete transaction log

Your name:

Reply:


Posted by Mike Epprecht \(SQL MVP\) on 12/20/05 16:48

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: mike@epprecht.net

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

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

<plsullivan63@gmail.com> wrote in message
news:1135089414.886821.49020@g43g2000cwa.googlegroups.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
>

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация