ADSM-L

Re: [ADSM-L] Issue with backup of SQL

2009-08-25 09:51:41
Subject: Re: [ADSM-L] Issue with backup of SQL
From: "Schaub, Steve" <steve_schaub AT BCBST DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 25 Aug 2009 09:50:49 -0400
My guess is that you have 6 offline databases, which TDP doesn't try to backup.

Steve Schaub
Systems Engineer, Windows
BlueCross BlueShield of Tennessee

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
TSM User
Sent: Tuesday, August 25, 2009 9:47 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Issue with backup of SQL

Hello all



I have a issue with backup of SQL (2005). TDP SQL 5.5.1



I run "tdpsqlc backup * full" ...



The result is shown below



Why  "Total SQL backups excluded: 6" if I have not excluded any DB ??



IBM Tivoli Storage Manager for Databases:

Data Protection for Microsoft SQL Server

Version 5, Release 5, Level 1.0

(C) Copyright IBM Corporation 1997, 2008. All rights reserved.



ACO5057I The C:\Archiv~1\Tivoli\TSM\TDPSql\sqlfull_log.log log file was
pruned successfully.



Connecting to SQL Server, please wait...

Starting SQL database backup...



Connecting to TSM Server as node 'SQL'...



Beginning log backup for database AAAAA, 1 of 53.

Full: 0   Read: 84736  Written: 84736  Rate: 77.70 Kb/Sec

Backup of AAAAA completed successfully.

.....................



Beginning log backup for database ZZZZZ, 53 of 53.

Full: 0   Read: 46848  Written: 46848  Rate: 38.58 Kb/Sec

Backup of ZZZZZ completed successfully.



Total SQL backups selected:               59

Total SQL backups attempted:              53

Total SQL backups completed:              53

Total SQL backups excluded:               6



Throughput rate:                          428.12 Kb/Sec

Total bytes transferred:                  23,664,320

Elapsed processing time:                  53.98 Secs

-----------------------------------------------------
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

<Prev in Thread] Current Thread [Next in Thread>