What version of SQLServer and the Windows operating system are you using?

Does your database have file groups?

What I would do if I was you - take a look at the script that runs as
part of the database backup maintenance plan and try duplicating that in
the restore.

In the past, when we set up our back/restore of our production database
to our reporting database server - we created a separate backup job and
named the backup, so we didn't have to figure out the current
maintenance plan name which included date/time stamp ~ ex: proddb.bak.

Dorothy Boesel wrote:
> I have backups from a production server that I am trying to restore on a
> dev server. The backups are done via maintenance plans. When I try to
> restore the backups on the dev server, I get the following error:
>
>
>
> The volume on device is not part of a multiple family media set
>
>
>
> I have each db backup going to its own db directory. Does anyone know
> how I can restore these files? What is the purpose of the maintenance
> plans for backing up multiple dbs, if I am not able to restore them?
>
>
>
> Thanks in Advance,
>
>
>
> Dorothy
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>

--

Cheryl Bach ~ UITS - Computer Data Base Spec, Prin
~ Admin Computing ~ University of Arizona

"Happiness is a choice that requires effort at times."
– Aeschylus

~~~~~~~~~~


MS Sql Server LazyDBA home page