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
