Re: Restoring SQL Database Question

2004-08-20 Thread Luc Beaudoin
Hi Del Thanks .. Have a nice weekend Del Hoobler <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 2004-08-20 08:51 AM Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:

Re: Restoring SQL Database Question

2004-08-20 Thread Del Hoobler
Luc, It looks fine... as long as: - "" is a TSM NODENAME that you have registered and received a password for. - "{IP TSM SERVER)" is actually the TCP/IP address of the TSM Server where the "" NODE is registered. Thanks, Del --

Re: Restoring SQL Database Question

2004-08-20 Thread Luc Beaudoin
r" To: [EMAIL PROTECTED] cc: Subject: Re: Restoring SQL Database Question Luc, Is a full backup "enough" for what? A Data Protection for SQL "FULL" backup can be used to restore a complete database. When a full backup is taken it al

Re: Restoring SQL Database Question

2004-08-19 Thread Del Hoobler
Luc, Is a full backup "enough" for what? A Data Protection for SQL "FULL" backup can be used to restore a complete database. When a full backup is taken it also captures pieces of the log that it needs to fully recover the database. You do not need a separate "LOG" backup in order to perform a da

Re: Restoring SQL Database Question

2004-08-19 Thread Luc Beaudoin
ease respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Re: Restoring SQL Database Question From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Luc Beaudoin >I'm doing backup of SQL 2000 on a WIN 2000 server

Re: Restoring SQL Database Question

2004-08-18 Thread Stapleton, Mark
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] 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 i

Re: Restoring SQL Database Question

2004-08-18 Thread Leonard, Christopher
Jeff, I didn't see anybody reply with anything better than what I know, so I thought I'd chime in. To do this, you will need to use TDPSQLC to query the TSM database for /ALL backups - not just the active ones. For example, "tdpsqlc query tsm mydatabase /all". Then you need to parse the output,