Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL Database Backup critical problem transaction log

0 views
Skip to first unread message

Innovations

unread,
Nov 25, 2009, 5:31:03 PM11/25/09
to
I am having a serious problem with a particular database. DPM says that the
database is inconsistent and no attempts to do a consistency check seems to
clear it.

Even worse, the transaction log of this database has grown to such a size
that any action on the database gives an error saying that the transaction
log is full. Even attempts to expand or add to the transaction logs gives
this error. The sys.databases table for the database says that the reason
why the transaction log cannot be reused is 2 - backup.

Alen Teplitsky

unread,
Nov 25, 2009, 9:00:29 PM11/25/09
to
On Nov 25, 5:31 pm, Innovations

backup log <database_name> with no_log will clear the log. try a
backup to disk using the native SQL tools and then DPM again

C.Prashanth [MSFT]

unread,
Nov 26, 2009, 12:11:20 PM11/26/09
to
Hi,
can you also paste the contents on replica invalid alert for that DB. also
check the eventviewer on the production server having the DB and see whether
any events have been raised by vss or sql writer when the job failed.

--
Thanks,
C.Prashanth [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights

"Alen Teplitsky" <alen...@gmail.com> wrote in message
news:9e79d6f4-3993-4ba4...@m3g2000yqf.googlegroups.com...

Hitesh Sharma[MSFT]

unread,
Nov 30, 2009, 2:33:16 AM11/30/09
to
Hi,

Have you scheduled incremental backups for the concerned database? By taking
log backups, the incremental backups at regular intervals will make sure
that logs get truncated.

Thanks,
Hitesh Sharma [MSFT]


This posting is provided "AS IS" with no warranties, and

confers no rights.

Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm
"Innovations" <Innov...@discussions.microsoft.com> wrote in message
news:854176B5-5309-47ED...@microsoft.com...

0 new messages