Problem Restoring an SQL 7.0 database to SQL 2000 - Database Not Published 
Author Message
 Problem Restoring an SQL 7.0 database to SQL 2000 - Database Not Published

I have a straightforward task that consistently fails.
I have a couple of databases on an active 7.0 instance of MSSQL
1) I made a database backup (standard) along with the verfy using
    Enterprise Manager-> Right Click on 'specific database, (eg. MyDB) ->
all tasks -> Backup Database
2) I move the dump file to the other machine
3) I go to the new installation of MSSQL 2000,
    Enterprise Manager-> Right Click on Databases -> all tasks -> Restore
Database.
    I name the databases, specify the from device, and set the options to
put the files into the right place on disk.
    I start the operation, it appears to complete, but at the very end a
error dialog appears....

           Error message indicates "The database is not published".

I have also tried to create the database on the new machine ahead of time,
and have published it as well, to no avail.
Any help will be greatly appreciated.

What can I do?
Thank you.
Rick



Sun, 24 Aug 2003 07:34:50 GMT
 Problem Restoring an SQL 7.0 database to SQL 2000 - Database Not Published

try using sp_attachdb and sp_detachdb

Quote:
-----Original Message-----

I have a straightforward task that consistently fails.
I have a couple of databases on an active 7.0 instance of MSSQL
1) I made a database backup (standard) along with the verfy using
    Enterprise Manager-> Right Click on 'specific database, (eg. MyDB) ->
all tasks -> Backup Database
2) I move the dump file to the other machine
3) I go to the new installation of MSSQL 2000,
    Enterprise Manager-> Right Click on Databases -> all tasks -> Restore
Database.
    I name the databases, specify the from device, and set the options to
put the files into the right place on disk.
    I start the operation, it appears to complete, but at the very end a
error dialog appears....

           Error message indicates "The database is not published".

I have also tried to create the database on the new machine ahead of time,
and have published it as well, to no avail.
Any help will be greatly appreciated.

What can I do?
Thank you.
Rick

.



Mon, 25 Aug 2003 01:38:19 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Problem Restoring an SQL 7.0 database to SQL 2000 - Database Not Published

2. Restoring a published database into SQL Server 2000

3. Restoring a published database into SQL Server 2000

4. restore sql 2000 database to sql server 7.0

5. Restoring database from SQL 2000 on SQL 7.0 server

6. Restoring SQL Server 7.0 database to SQL Server 2000 Environment Question

7. SQL 2000 database restored to SQL 7.0

8. Restore database from SQL Server 2000 to SQL Server 7.0

9. Restoring SQL 7.0 databases to SQL 2000

10. Restoring msdb database from SQL Server 7.0 backup to SQL Server 2000

11. Restoring a SQL 2000 database on SQL 7.0

12. Can I restore SQL 2000 database in SQL 7.0


 
Powered by phpBB® Forum Software