|
Posted by Mark D Powell on 10/02/39 11:55
francois1@verismall.com wrote:
> I am running a website with a SQL Server database attached.
> My transaction logs are full and my hosting co. won't allocate more
> disk space for me.
>
> I need to delete my database transaction logs and asume I will need to
> run an SQL script to do this.
>
> Problem: I do not have MS Enterprise Manager of any database utility
> on my website apart from MS Access. Where can I download a free SQL
> tool that I can use to delete the transaction logs from my database.
>
> Any help appreciated.
>
> Thanks
>
> Francois Terblanche
> verismall.com
-- Apologies if this is a duplicate reply but I got a page cannot be
displayed error reply to the post message action
Is your database in SIMPLE or FULL backup mode? If SIMPLE then ask the
host provider to have their database support team run a backup and
perform a DBCC SHRINKFILE on the log files.
If as I would expect it is in FULL ask the host provider to run a
transaction log backup. Also inquire as to how frequently the
transaction logs are backed up?
If there is no space to run the backups ask the host provider how many
backups are being kept? If more than the last is still available on
disk you should be able to have the oldest backups deleted to make
space for the new backup.
HTH -- Mark D Powell --
Navigation:
[Reply to this message]
|