Wednesday, March 7, 2012

Restore a DB

I am trying to restore a DB from a BackUp File
but I get the foll msg..
Any suggestions ? Thanks in advance.
Server: Msg 3132, Level 16, State 1, Line 1
The media set for database 'AAD_GSA' has 2 family members
but only 1 are provided. All members must be provided.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.i think you have backed up the database on more than one backup devices.
Therefore you will have to specify all the devices that you have specified
at the time of backup to perform restore operation successfully.
see following example
--create 2 backup devices
use master
go
sp_addumpdevice 'disk', 'mydiskdump','c:\northwind.bak'
go
sp_addumpdevice 'disk','mydiskdump1', 'c:\northwind1.bak'
go
--backup database on both of them
backup database northwind to mydiskdump,mydiskdump1
--if you try to restore from one device it will give you for the restore
statement as follows.
restore database Northwind from mydiskdump
--you will have to specify both the devices at the time of backup.
restore database Northwind from mydiskdump, mydiskdump1
--
-Vishal
"ABonik" <ABONEIK@.hotmail.com> wrote in message
news:027a01c37174$4fd8a910$a101280a@.phx.gbl...
> I am trying to restore a DB from a BackUp File
> but I get the foll msg..
> Any suggestions ? Thanks in advance.
> Server: Msg 3132, Level 16, State 1, Line 1
> The media set for database 'AAD_GSA' has 2 family members
> but only 1 are provided. All members must be provided.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.|||perhaps you did a backup to 2 backup devices; when you restore you specify
only 1 device?
"ABonik" <ABONEIK@.hotmail.com> wrote in message
news:027a01c37174$4fd8a910$a101280a@.phx.gbl...
> I am trying to restore a DB from a BackUp File
> but I get the foll msg..
> Any suggestions ? Thanks in advance.
> Server: Msg 3132, Level 16, State 1, Line 1
> The media set for database 'AAD_GSA' has 2 family members
> but only 1 are provided. All members must be provided.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.

No comments:

Post a Comment