Re: TSM SQL restore
2007-03-08 08:41:21
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 (mark.s AT evolvingsol DOT com)
Senior consultant
________________________________
From: ADSM: Dist Stor Manager on behalf of Del Hoobler
Sent: Wed 3/7/2007 3:37 PM
To: ADSM-L AT VM.MARIST DOT EDU
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" <ADSM-L AT VM.MARIST DOT EDU> 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 (mark.s AT evolvingsol DOT com)
> Senior consultant
|
|
|