December 20, 2009 at 5:19 am
The transaction log on hosting took an excessive size. Once he was truncated when assistance
BACKUP LOG "db" WITH TRUNCATE_ONLY
Go
DBCC SHRINKFILE (db_log)
GO
A now says
"Cannot perform a backup or restore operation within a transaction.
BACKUP LOG is terminating abnormally."
the quota databases I exhausted. Help me?
December 20, 2009 at 11:08 am
Who recommended truncating the transaction log?
Are you performing regular and frequent transaction log backups? If not, why are you running in full recovery model?
Once you issued that command, you broke the log chain and need to perform a full backup to re-instate it. Please review the article about managing transaction log files that I link to in my signature.
In the future, do not truncate the log file. The correct way to free up space so you can shrink the log if it has grown too large is to back it up normally. However, if your log file has grown for some reason - it is very likely that it will grow to that size again. Shrinking it just causes it to have to grow slowing your system down while it does so.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 20, 2009 at 11:51 am
I on hosting quota database 400MB. Base 250MV data and 160MB in the transaction log (0MB used space, unused 160MB). I can not backup base, receive the message of the ban. How can I reduce the size of the transaction log?
December 20, 2009 at 11:57 am
the error iscomplaining about running the backup in a transaction. How are you trying to backup the database?
post the code if you are doing it using T-SQL code.
---------------------------------------------------------------------
December 20, 2009 at 12:22 pm
I don't have T-SQL code. I'm using SQL management Studio 2007 (my base SQL Server 2005). I choose Tasks - Backing up a database - Select a server, a full backup - no backup device. I'm trying to create a backup device, get the message: "User does not have permission to perform this action"
December 20, 2009 at 12:31 pm
backup to a file, not a device.
backing up the database will not shrink the tran log if that is what you are expecting, but at 160mb I would not call it excessive anyway.
If it turns out you do not have permissions to backup databases, get in touch with whoever does and tell them you need a full backup as the log has been truncated.
---------------------------------------------------------------------
December 20, 2009 at 12:47 pm
Thank you, I really havn't access there. I shall contact support.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply