Restore Sql Server 2005 db to Sql Server 2000  
Author Message
wrobo





PostPosted: Thu Dec 14 22:06:33 CST 2006 Top

SQL Server Developer >> Restore Sql Server 2005 db to Sql Server 2000

I have a database that was backed up on a SQL Server 2005 system. Is it
possible to restore the database to a SQL Server 2000 system?

SQL Server1  
 
 
Tom





PostPosted: Thu Dec 14 22:06:33 CST 2006 Top

SQL Server Developer >> Restore Sql Server 2005 db to Sql Server 2000 No.

Tom



>I have a database that was backed up on a SQL Server 2005 system. Is it
> possible to restore the database to a SQL Server 2000 system?
>


 
 
Hari





PostPosted: Thu Dec 14 23:05:20 CST 2006 Top

SQL Server Developer >> Restore Sql Server 2005 db to Sql Server 2000 Hello,


Due to architectural differences you can not RESTORE a SQL 2005 datbase into
SQL 2000 server. What you can do is create the database manually and use DTS
to transfer objects and data
from SQL 2005 database to SQL 2000.

Thanks
Hari



>I have a database that was backed up on a SQL Server 2005 system. Is it
> possible to restore the database to a SQL Server 2000 system?
>


 
 
SalP





PostPosted: Thu Dec 14 23:11:08 CST 2006 Top

SQL Server Developer >> Restore Sql Server 2005 db to Sql Server 2000 I have SQLEXPRESS which came with my Visual Studio 2005 Upgrade and I
just installed Management Studio Express. It allowed me to restore my
2005 Backup. SQLEXPRESS and the MSE is really slick. I'm impressed that
it came with my Visual Studio 2005 Upgrade.




> No.
>
> Tom
>


> >I have a database that was backed up on a SQL Server 2005 system. Is it
> > possible to restore the database to a SQL Server 2000 system?
> >