ADSM-L

Restoring SQL Database Question

2004-08-18 12:02:18
Subject: Restoring SQL Database Question
From: Luc Beaudoin <lbeaudoi AT IS.JGH.MCGILL DOT CA>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 18 Aug 2004 12:02:14 -0400
HI all

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)

What is the best way ???

thanks

Luc