ADSM-L

TDP for SQL log backup

2003-12-22 13:24:36
Subject: TDP for SQL log backup
From: Joe Crnjanski <JCrnjanski AT INFINITYNETWORK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 22 Dec 2003 13:24:40 -0500
Hi All,

We have one client that we used to dump database file with SQL Enterprise 
Manager backup scheduled utility.
After dump database we would just back it up with regular B/A client.

Now we started using TDP. It worked fine on full backup. On log backup it is 
backing up same size as full backup. It says in activity log that it is doing 
log backup. If I check database and log size in Enterprise manager; DB 800MB, 
Log 150MB
If I do manual full backup from tdp gui it backs up around 1GB, same if I do 
log backup. There is nothing else in the log indicating why log backup is so 
big.

TSM Server 5.1.8.0
B/A client 5.1.6.9
TDP for SQL 5.1.5

Client:
Win2ksvr sp4
SQL 2000 sp3a

Joe Crnjanski
Infinity Network Solutions Inc.
Phone: 416-235-0931 x26
Fax:     416-235-0265
Web:  www.infinitynetwork.com

<Prev in Thread] Current Thread [Next in Thread>
  • TDP for SQL log backup, Joe Crnjanski <=