Showing posts with label provided. Show all posts
Showing posts with label provided. Show all posts

Monday, March 12, 2012

Restore Problem (6.5)

I need to restore a SQL 6.5 database dump onto my laptop. Unfortunately I
don't have enought disk space, so work has kindly provided a USB external
hard disk. I can create the device on that disk, but what I try and restore
the database. It comes up with a 'Unable to write to server-side connection'
error message.
Any ideas ?
Cheers
MarkHi,
After creating the device , did you tried creating the database. The size
should be identical to the source database from where you received the dump
file.
Give me more information about,
1. Location of Dump file
2. Are you able to see the logical drives (newly attached external disk)
from explorer?
If you still have issues , try creating a table on the new database created.
Thanks
Hari.
MCDBA
"Flems" <Mark.Flemans@.apakgroup.com> wrote in message
news:uLYdnMXvDHA.1788@.tk2msftngp13.phx.gbl...
> I need to restore a SQL 6.5 database dump onto my laptop. Unfortunately I
> don't have enought disk space, so work has kindly provided a USB external
> hard disk. I can create the device on that disk, but what I try and
restore
> the database. It comes up with a 'Unable to write to server-side
connection'
> error message.
> Any ideas ?
> Cheers
> Mark
>

Friday, March 9, 2012

restore of msdb database

I try to restore the msdb database. i get the error "the media set for
database msdb has 2 family members byt only 1 are provided. all members must
be provided. restore database is terminating abnormally. i have followed the
procedure to restore msdb.
The error message states that when you performed the backup, you striped it over two backup devices.
This can be verified using RESTORE LABELONLY. You need to find both in order to do restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"joia" <joia@.discussions.microsoft.com> wrote in message
news:F2A56209-B3A6-4DB7-BFAB-2247F98A9C87@.microsoft.com...
>I try to restore the msdb database. i get the error "the media set for
> database msdb has 2 family members byt only 1 are provided. all members must
> be provided. restore database is terminating abnormally. i have followed the
> procedure to restore msdb.

restore of msdb database

I try to restore the msdb database. i get the error "the media set for
database msdb has 2 family members byt only 1 are provided. all members must
be provided. restore database is terminating abnormally. i have followed the
procedure to restore msdb.The error message states that when you performed the backup, you striped it over two backup devices.
This can be verified using RESTORE LABELONLY. You need to find both in order to do restore.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"joia" <joia@.discussions.microsoft.com> wrote in message
news:F2A56209-B3A6-4DB7-BFAB-2247F98A9C87@.microsoft.com...
>I try to restore the msdb database. i get the error "the media set for
> database msdb has 2 family members byt only 1 are provided. all members must
> be provided. restore database is terminating abnormally. i have followed the
> procedure to restore msdb.