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