Chris,
I have a few comments:
RESTORE VERIFYONLY checks to see that the backup set is complete
and that all volumes are readable. RESTORE VERIFYONLY does NOT
check the structure of the data on the volumes.
I always wondered how this is a "verification" of a restore
if you don't really restore th
Is your DBA talking about shrinking the log file or truncating the log? One
thing to look out for here is the fact that these are two different things,
and lots of SQL people can get confused about this. Truncating a SQL Server
log is not the same as shrinking the physical file that houses the lo
ns Inc.
> Phone: 416-235-0931 x26
> Fax: 416-235-0265
> Web: www.infinitynetwork.com
>
>
>
> -Original Message-
> From: David Longo [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 05, 2004 5:38 PM
> To: [EMAIL PROTECTED]
> Subject: TDP SQL Transaction log
ngo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:41 AM
To: [EMAIL PROTECTED]
Subject: Re: TDP SQL Transaction log not truncating
Can you reference me an MS SQL doc or something on this? My
SQL DBA's are kind of anti-TSM, so I need as much justification
on this as I can get to g
mailto:[EMAIL PROTECTED]
Sent: Monday, April 05, 2004 5:38 PM
To: [EMAIL PROTECTED]
Subject: TDP SQL Transaction log not truncating
I have TSM server 4.2.3.4 on AIX and two clients each running W2K, SP2.
The two clients have SQL server and I use TDP SQL for hot backups
and do log backups of one
04 5:38 PM
To: [EMAIL PROTECTED]
Subject: TDP SQL Transaction log not truncating
I have TSM server 4.2.3.4 on AIX and two clients each running W2K, SP2.
The two clients have SQL server and I use TDP SQL for hot backups
and do log backups of one of the DB's every hour or two. A FULL
backup
I have TSM server 4.2.3.4 on AIX and two clients each running W2K, SP2.
The two clients have SQL server and I use TDP SQL for hot backups
and do log backups of one of the DB's every hour or two. A FULL
backup of all DB's is done once a day. I use the sqlfull.smp script
with minimum change for ou
