Very similar. I get this: D:\TDPSql>tdpsqlc restore DBA_Admin full /fromsqlserver=SDHQ04-DEVSQL04 IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server Version 5, Release 3, Level 3.0 (C) Copyright IBM Corporation 1997, 2006. All rights reserved. Starting Sql database restore... Querying Tivoli Storage Manager server for a list of database backups, please wait... ACO0261I There are no backups for the server named SDHQ04-DEVSQL04\meta\0000.
And I know there are backups there. -- Mark Stapleton ([EMAIL PROTECTED]) Senior consultant ________________________________ From: ADSM: Dist Stor Manager on behalf of Del Hoobler Sent: Wed 3/7/2007 3:37 PM To: [email protected] Subject: Re: [ADSM-L] TSM SQL restore Did you try something like this? tdpsqlc restore DB_Stuff full /fromsqlserver=SERVER1 tdpsqlc restore DB_Stuff log=* /fromsqlserver=SERVER1 Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <[email protected]> wrote on 03/07/2007 04:21:48 PM: > I'm having the hardest time with doing something with an SQL restore. > > I can't seem to get the syntax right on what *should* be a simple exercise: > > If I want to restore an SQL database (called DB_Stuff), backed up > from SERVER1, to SERVER2 (physically separate servers with eponymous > SQL instances), what the hell is the syntax for restoring the full > backup, plus say a half-dozen log files? > > Must be age or something, because I can't get the darned syntax > right. There really needs to be an example of that somewhere in the > documentation, since that is a classic exercise during a partial disaster. > > -- > Mark Stapleton ([EMAIL PROTECTED]) > Senior consultant
