What does the following error message mean encountered whilst attempting to
restore a SQL Server 2000 database?
'The backed-up database has on-disk structure version 539. The server
supports version 515 and cannot restore or upgrade this database.'AFAIK, this usually means the backup was made by a version of sql server
that is **more** current than the one you are using to restore.
"T." <T@.discussions.microsoft.com> wrote in message
news:929A4958-2E6C-4C76-8F8F-5EAB6E1EB735@.microsoft.com...
> What does the following error message mean encountered whilst attempting
to
> restore a SQL Server 2000 database?
> 'The backed-up database has on-disk structure version 539. The server
> supports version 515 and cannot restore or upgrade this database.'|||Those version numbers say that you're trying to restore a SQL Server 2000
database on a 7.0 server. As Scott says, you can't restore databases to a
down-level server.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:#YuDROeDFHA.3888@.TK2MSFTNGP09.phx.gbl...
> AFAIK, this usually means the backup was made by a version of sql server
> that is **more** current than the one you are using to restore.
> "T." <T@.discussions.microsoft.com> wrote in message
> news:929A4958-2E6C-4C76-8F8F-5EAB6E1EB735@.microsoft.com...
> > What does the following error message mean encountered whilst attempting
> to
> > restore a SQL Server 2000 database?
> >
> > 'The backed-up database has on-disk structure version 539. The server
> > supports version 515 and cannot restore or upgrade this database.'
>|||Thanks both of you. What I suspected.
"Paul S Randal [MS]" wrote:
> Those version numbers say that you're trying to restore a SQL Server 2000
> database on a 7.0 server. As Scott says, you can't restore databases to a
> down-level server.
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Scott Morris" <bogus@.bogus.com> wrote in message
> news:#YuDROeDFHA.3888@.TK2MSFTNGP09.phx.gbl...
> > AFAIK, this usually means the backup was made by a version of sql server
> > that is **more** current than the one you are using to restore.
> >
> > "T." <T@.discussions.microsoft.com> wrote in message
> > news:929A4958-2E6C-4C76-8F8F-5EAB6E1EB735@.microsoft.com...
> > > What does the following error message mean encountered whilst attempting
> > to
> > > restore a SQL Server 2000 database?
> > >
> > > 'The backed-up database has on-disk structure version 539. The server
> > > supports version 515 and cannot restore or upgrade this database.'
> >
> >
>
>
No comments:
Post a Comment