Hi again

Is a full backup enought or I should take a backup of the log too ??
Is there any settings to look at in the DSM.OPT for SQL ??






"Stapleton, Mark" <mark.stapleton AT BERBEE DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2004-08-18 12:34 PM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: Restoring SQL Database Question


From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
Behalf Of Luc Beaudoin
>I'm doing backup of SQL 2000 on a WIN 2000 server.
>
>the way i'm doing it is ::: with a batch file .. and the
>command line is :
>
>      \...\tpdsqlc backup * full /tsmoptfile\dsm.opt ....
>
>The problem I have is that I need to restore one SQL DB from 2
>days ago and I dont see how ... (my policy keeps 14 versions)
>
>Does anyone knows the way to take a real full backup of an SQL
>db (with transaction log .. or not)

Your current batch file *is* kicking off full SQL database backups.

To restore a backup that is not the latest one, you'll probably want to
use the TSM for Database (SQL)'s GUI interface, select the restore tab,
examine all backups of your desired file, select the backup you want,
and start the restore. Keep in mind that by default, the restore will
overwrite the existing database. Refer to the TSM for Databases (SQL)
user manual for how to restore an SQL database to an alternate location,
if you don't want to overwrite the existing database.

--
Mark Stapleton