Wednesday, March 21, 2012

Recovering database from backup

We have a backup for database which was made on SQL 2000. Is there a way to recover it on SQL 7, or MS Access 2003?
No. You can't restore SQL Server 2000 backups on a SQL Server 7 server. If
you have MSDE 2000 with MS Access 2003, you might be able to restore the
database if it's size doesn't exceed the limit for MSDE, which is 2 GB. You
can always download MSDE 2000 from www.microsoft.com/sql if you need it.
Jacco Schalkwijk
SQL Server MVP
"Luis" <Luis@.discussions.microsoft.com> wrote in message
news:A82E35E5-77E3-40B2-9675-517FC3EDE9E2@.microsoft.com...
> We have a backup for database which was made on SQL 2000. Is there a way
to recover it on SQL 7, or MS Access 2003?

No comments:

Post a Comment