ADSM-L

Re: sql 2.2.1

2002-11-14 07:58:55
Subject: Re: sql 2.2.1
From: "Amini, Mehdi" <Mehdi.Amini AT VALUEOPTIONS DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 14 Nov 2002 07:58:45 -0500
Thanks.. I will try that.  Can you possibly email me an example of your
DSM.OPT for SQL.



Mehdi Amini
LAN/WAN Engineer
ValueOptions
12369 Sunrise Valley Drive
Suite C
Reston, VA 20191
Phone: 703-390-6855
Fax: 703-390-2581


-----Original Message-----
From: Edgardo Moso [mailto:edgardo_moso AT KINDREDHEALTHCARE DOT COM]
Sent: Thursday, November 14, 2002 7:54 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: sql 2.2.1


Mehdi,

I am just curious of on error.  I have a lot of TDP installed and I'm not
getting this kind of error.
Can you please try this sqlfull.cmd?

rem
rem  This is the default SQLTEST.CMD file for TDP2.2 - created 7/19/01
rem  this backs pubs to adsm
rem @ECHO OFF
set sql_dir=C:\adsm\TDPSql
C:
cd %sql_dir%
rem  ==================================================================
rem   2 lines below put a date and time stamp in a log file for you.
rem  ==================================================================
date < NUL >> %sql_dir%\sqlsched.log
time < NUL >> %sql_dir%\sqlsched.log
%sql_dir%\tdpsqlc backup pubs full /tsmoptfile=%sql_dir%
\adsm\tdpsql\dsm.opt /sqlserver=<sqlserver_instance> /logfile=%sql_dir%
\sqlfull.log >> %sql_dir%\sqlsched.log

This will backup the pubs dB and save an output to log sqlfull.log and
another log sqlsched.log.

You can create a test schedule and call this sqltest.cmd as an object.  If
this the backup is successfull you can see sqlfull.log that looks like
this:

07/24/2002 16:39:16 Request                       : FULL BACKUP
07/24/2002 16:39:16 Database Input List           : pubs
07/24/2002 16:39:16 Group Input List              : -
07/24/2002 16:39:16 File Input List               : -
07/24/2002 16:39:16 Number of Buffers             : 3
07/24/2002 16:39:16 Buffer Size                   : 1024
07/24/2002 16:39:16 Number of SQL Buffers         : 0
07/24/2002 16:39:16 SQL Buffer Size               : 1024
07/24/2002 16:39:16 Number of Stripes specified   : 1
07/24/2002 16:39:16 Estimate                      : -
07/24/2002 16:39:16 Truncate Log?                 : -
07/24/2002 16:39:16 Wait for Tape Mounts?         : Yes
07/24/2002 16:39:16 TSM Options File              : C:\adsm\TDPSql\dsm.opt
07/24/2002 16:39:16 TSM Nodename Override         : -
07/24/2002 16:39:16 Sqlserver                     : VC0699NTW1
07/24/2002 16:39:16
07/24/2002 16:39:21 Total SQL backups selected:               1
07/24/2002 16:39:21 Total SQL backups attempted:              1
07/24/2002 16:39:21 Total SQL backups completed:              1
07/24/2002 16:39:21 Total SQL backups excluded:               0
07/24/2002 16:39:21 Total SQL backups inactivated:            0
07/24/2002 16:39:21 Throughput rate:                          578.89 Kb/Sec
07/24/2002 16:39:21 Total bytes transferred:                  1,786,640
07/24/2002 16:39:21 Elapsed processing time:                  3.01 Secs


Hope this will help.

Edgardo Moso
Sr. System Programmer


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the sender by email, delete and destroy this message and its
attachments.


**********************************************************************

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