|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > restore error
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]
|
|
| zzzzzz 2002-11-20, 1:24 pm |
| An error occurred on a query to filegroup MS_SERVER_100949_1724..PRIMARY.
^ ^ ^ ^ ^
One or more of the options (recovery) are not supported for this statement.
Review the documentation for supported options.
^ ^ ^ ^ ^
This error is reported while restoring the database ( SQL 2000 ) by using
Veritas Backup Exec.
Database size is 16 GB
Any SP related issue ?
thx
| |
|
| What was the query? Were you trying to restore while running it?
"zzzzzz" <zzzzzz@zzzz.com> wrote in message
news:#lTYYfMkCHA.1700@tkmsftngp09.mirrorpost...
> An error occurred on a query to filegroup MS_SERVER_100949_1724..PRIMARY.
> ^ ^ ^ ^ ^
> One or more of the options (recovery) are not supported for this
statement.
> Review the documentation for supported options.
> ^ ^ ^ ^ ^
>
> This error is reported while restoring the database ( SQL 2000 ) by using
> Veritas Backup Exec.
> Database size is 16 GB
> Any SP related issue ?
> thx
>
>
>
| |
| zzzzzz 2002-11-20, 2:23 pm |
| no, we did not. - I guess so. Few days ago , it was fine. Then after 2
weeks, it started giving this error. Something has been changed .
thx
"chris" <chris@fin2000.com> wrote in message
news:OggH7wMkCHA.2672@tkmsftngp09...
> What was the query? Were you trying to restore while running it?
> "zzzzzz" <zzzzzz@zzzz.com> wrote in message
> news:#lTYYfMkCHA.1700@tkmsftngp09.mirrorpost...
> > An error occurred on a query to filegroup
MS_SERVER_100949_1724..PRIMARY.
> > ^ ^ ^ ^ ^
> > One or more of the options (recovery) are not supported for this
> statement.
> > Review the documentation for supported options.
> > ^ ^ ^ ^ ^
> >
> > This error is reported while restoring the database ( SQL 2000 ) by
using
> > Veritas Backup Exec.
> > Database size is 16 GB
> > Any SP related issue ?
> > thx
> >
> >
> >
>
>
| |
| Tibor Karaszi 2002-11-21, 2:23 am |
| I suggest you take this to Veritas. Seems to be a problem in the SQL commands that they submit.
If you want to troubleshoot this yourself, use Profiler to catch the RESTORE commands submitted.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"zzzzzz" <zzzzzz@zzzz.com> wrote in message news:u7YK8$MkCHA.440@tkmsftngp11...
> no, we did not. - I guess so. Few days ago , it was fine. Then after 2
> weeks, it started giving this error. Something has been changed .
> thx
>
> "chris" <chris@fin2000.com> wrote in message
> news:OggH7wMkCHA.2672@tkmsftngp09...
> > What was the query? Were you trying to restore while running it?
> > "zzzzzz" <zzzzzz@zzzz.com> wrote in message
> > news:#lTYYfMkCHA.1700@tkmsftngp09.mirrorpost...
> > > An error occurred on a query to filegroup
> MS_SERVER_100949_1724..PRIMARY.
> > > ^ ^ ^ ^ ^
> > > One or more of the options (recovery) are not supported for this
> > statement.
> > > Review the documentation for supported options.
> > > ^ ^ ^ ^ ^
> > >
> > > This error is reported while restoring the database ( SQL 2000 ) by
> using
> > > Veritas Backup Exec.
> > > Database size is 16 GB
> > > Any SP related issue ?
> > > thx
> > >
> > >
> > >
> >
> >
>
>
|
|
|
|
|