vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I am setting up a job to automatically restore the standby database. This is to test our tape backups. I need to passon the latest full backup and log file names to the tape system to extract the files. How do I get the file names? I would like to store these file names in temp table and pass on to tape system one by one to extract it to local disk. Do I need to query the msdb of primary or backup directory? Please suggest sql to achieve this. Thanks Tram |