Hi All,
I'm sunig SQL server for Project Server and I accidentally
deleted the Project server database!!! Then
I tried to restores it form the Recycle bin but it didnt
go back. I have made backups but I get these error
messages when I try to restore:
The Volume on Drive C:\SQL backup\backup is not a part of
media family set. Backup with format can be used to form a
new media set.
Restore is terminated abnormally.
OR:
There is a logic device associated to the disk file name
you just selected. Please select the logic device instead
or specify a new disk file name.
Does anybody know what I need to do?
Thanks,
Sittania
.Hi Sitania,
Can you provide which version of SQL Server you are running? How are you
attempting to restore the backup (using Enterprise Manager GUI, or a
script)?
--
Dan Holt [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sitania" <sittania@.yahoo.com> wrote in message
news:016201c35de5$48cd1680$a501280a@.phx.gbl...
> Hi All,
> I'm sunig SQL server for Project Server and I accidentally
> deleted the Project server database!!! Then
> I tried to restores it form the Recycle bin but it didnt
> go back. I have made backups but I get these error
> messages when I try to restore:
>
> The Volume on Drive C:\SQL backup\backup is not a part of
> media family set. Backup with format can be used to form a
> new media set.
> Restore is terminated abnormally.
> OR:
> There is a logic device associated to the disk file name
> you just selected. Please select the logic device instead
> or specify a new disk file name.
> Does anybody know what I need to do?
> Thanks,
> Sittania
> .
>|||Hi Dan,
Thanks for your reply.I don’t know what was going on but I
fixed it. Im not very familiar with SQL, I just use it as
the database for Project server. I made some backups by
right clicking on the
Project Server Database > All tasks > Backup data base.
And I didnt schedule it to backup regularly but its
backing up the database at 12:00 AM every day. When I
tried to restore it would give me all the backup files
created and whichever I picked it would not take it. So I
deleted all the backup files except one and it worked, I
don’t know how, but it took it!! I guess I need to do some
research on SQL to learn more. Is there a book or website
I can get information from?
I really appreciate your help.
Sittania
>--Original Message--
>Hi Sitania,
>Can you provide which version of SQL Server you are
running? How are you
>attempting to restore the backup (using Enterprise
Manager GUI, or a
>script)?
>--
>Dan Holt [MSFT]
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>"Sitania" <sittania@.yahoo.com> wrote in message
>news:016201c35de5$48cd1680$a501280a@.phx.gbl...
>> Hi All,
>> I'm sunig SQL server for Project Server and I
accidentally
>> deleted the Project server database!!! Then
>> I tried to restores it form the Recycle bin but it didnt
>> go back. I have made backups but I get these error
>> messages when I try to restore:
>>
>> The Volume on Drive C:\SQL backup\backup is not a part
of
>> media family set. Backup with format can be used to
form a
>> new media set.
>> Restore is terminated abnormally.
>> OR:
>> There is a logic device associated to the disk file name
>> you just selected. Please select the logic device
instead
>> or specify a new disk file name.
>> Does anybody know what I need to do?
>> Thanks,
>> Sittania
>> .
>>
>
>.
>|||Hi Sittania,
Great! I'm glad that you resolved the issue. Keep running that backup
schedule...it is always important to have them!
Books Online (installed with SQL Server) has a wealth of information,
samples and definitions. http://www.microsoft.com/sql is the official
website for SQL Server. There are also many quality websites and
organizations dedicated to SQL Server: just use your favorite search engine
to find them. Try searching for 'SQL Server tips', 'SQL Server help', 'SQL
Server Community' or 'Microsoft SQL Server' (for a start). There are also
many user groups that get together monthly to discuss topics of interest to
SQL Server...check the Microsoft website for events in your area.
You also already know about the newsgroups: these are some of the greatest
resources available today. Please let us know how we can help!
--
Dan Holt [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sittania" <sittania@.yahoo.com> wrote in message
news:096e01c35e03$d1d16620$a001280a@.phx.gbl...
> Hi Dan,
> Thanks for your reply.I don’t know what was going on but I
> fixed it. Im not very familiar with SQL, I just use it as
> the database for Project server. I made some backups by
> right clicking on the
> Project Server Database > All tasks > Backup data base.
> And I didnt schedule it to backup regularly but its
> backing up the database at 12:00 AM every day. When I
> tried to restore it would give me all the backup files
> created and whichever I picked it would not take it. So I
> deleted all the backup files except one and it worked, I
> don’t know how, but it took it!! I guess I need to do some
> research on SQL to learn more. Is there a book or website
> I can get information from?
> I really appreciate your help.
> Sittania
> >--Original Message--
> >Hi Sitania,
> >
> >Can you provide which version of SQL Server you are
> running? How are you
> >attempting to restore the backup (using Enterprise
> Manager GUI, or a
> >script)?
> >
> >--
> >Dan Holt [MSFT]
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >
> >
> >"Sitania" <sittania@.yahoo.com> wrote in message
> >news:016201c35de5$48cd1680$a501280a@.phx.gbl...
> >> Hi All,
> >> I'm sunig SQL server for Project Server and I
> accidentally
> >> deleted the Project server database!!! Then
> >> I tried to restores it form the Recycle bin but it didnt
> >> go back. I have made backups but I get these error
> >> messages when I try to restore:
> >>
> >>
> >> The Volume on Drive C:\SQL backup\backup is not a part
> of
> >> media family set. Backup with format can be used to
> form a
> >> new media set.
> >>
> >> Restore is terminated abnormally.
> >>
> >> OR:
> >>
> >> There is a logic device associated to the disk file name
> >> you just selected. Please select the logic device
> instead
> >> or specify a new disk file name.
> >>
> >> Does anybody know what I need to do?
> >>
> >> Thanks,
> >> Sittania
> >>
> >> .
> >>
> >>
> >
> >
> >.
> >
No comments:
Post a Comment