Restoring SQL Database Question
2004-08-18 12:02:18
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
|
|
|