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

Quote:
> 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:36:27 GMT
 
 [ 1 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 database from SQL Server 2000 to SQL Server 7.0

5. Restoring a SQL 2000 database on SQL 7.0

6. Restoring database from SQL 2000 on SQL 7.0 server

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

8. Can I restore SQL 2000 database in SQL 7.0

9. Restoring SQL 7.0 databases to SQL 2000

10. SQL 2000 database restored to SQL 7.0

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

12. restore sql 2000 database to sql server 7.0


 
Powered by phpBB® Forum Software