|
Home > Archive > SQL Server Migration Assistant > March 2006 > Cannot backup MSSQL databases
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cannot backup MSSQL databases
|
|
| maxman 2006-03-06, 7:30 pm |
| Hi,
I tried to backup my database in my SQL Server to file G:\newtest
server\data (there a another list of backup folder there), it was saved
succesfully the first time, but I deleted the backup from the folder and
tried abain The second time an error appears : "The media set for database
"myData" has 2 family members, but only 1 are provided. all members must be
provided. Backup or restore operation terminating abnormally".
Any help would be apperciated
Urgent
Thank you
--
maxman
| |
| maxman 2006-03-06, 7:30 pm |
| i am using MSSQL 2000 not mysql
Thank you
--
maxman
"maxman" wrote:
> Hi,
> I tried to backup my database in my SQL Server to file G:\newtest
> server\data (there a another list of backup folder there), it was saved
> succesfully the first time, but I deleted the backup from the folder and
> tried abain The second time an error appears : "The media set for database
> "myData" has 2 family members, but only 1 are provided. all members must be
> provided. Backup or restore operation terminating abnormally".
>
> Any help would be apperciated
>
> Urgent
>
> Thank you
>
>
> --
> maxman
| |
| Andrew J. Kelly 2006-03-06, 7:30 pm |
| How did you try to back it up? Were you using EM or a script? This appears
to indicate a previous backup was done using more than one device of which
is no longer there. I suggest you start from scratch and attempt the backup
again and do not use any of the existing devices.
--
Andrew J. Kelly SQL MVP
"maxman" <maxman@discussions.microsoft.com> wrote in message
news:BEF4C9D9-E8F6-4FD7-B570- 335B4E806275@microso
ft.com...
> Hi,
> I tried to backup my database in my SQL Server to file G:\newtest
> server\data (there a another list of backup folder there), it was saved
> succesfully the first time, but I deleted the backup from the folder and
> tried abain The second time an error appears : "The media set for database
> "myData" has 2 family members, but only 1 are provided. all members must
> be
> provided. Backup or restore operation terminating abnormally".
>
> Any help would be apperciated
>
> Urgent
>
> Thank you
>
>
> --
> maxman
| |
| maxman 2006-03-06, 7:30 pm |
| I am using Enterprise Manager, and have tried to do the backup using follders
on different drives drive, but I cannot do the backup a second time.
Thanks
maxman
--
maxman
"Andrew J. Kelly" wrote:
> How did you try to back it up? Were you using EM or a script? This appears
> to indicate a previous backup was done using more than one device of which
> is no longer there. I suggest you start from scratch and attempt the backup
> again and do not use any of the existing devices.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "maxman" <maxman@discussions.microsoft.com> wrote in message
> news:BEF4C9D9-E8F6-4FD7-B570- 335B4E806275@microso
ft.com...
>
>
>
| |
| Andrew J. Kelly 2006-03-06, 7:30 pm |
| Have you tried doing it with the BACKUP command thru Query Analyzer?
--
Andrew J. Kelly SQL MVP
"maxman" <maxman@discussions.microsoft.com> wrote in message
news:0BD658A8-2431-4E31-BE59- 374ABEE13327@microso
ft.com...[color=darkred]
>I am using Enterprise Manager, and have tried to do the backup using
>follders
> on different drives drive, but I cannot do the backup a second time.
>
> Thanks
>
> maxman
> --
> maxman
>
>
> "Andrew J. Kelly" wrote:
>
|
|
|
|
|