SQL Server 2005 Express 1

[vlingen]

Through my job I've been assigned to customers who have different SQL systems....

Anyone know can you backup a SQL Server 2000 database and restore it to a SQL Server 2005 Express? or to MSDE?

Is there a reason I should try to install more than one of these systems on my laptop at the sametime?

Thanks.

 

[gmmastros]

You can safely install sql 2000 and sql 2005 on the same computer. In fact, under the right circumstances it is recommended.

If you only install sql express and you attach a sql 2000 database to it, then it will automatically be upgraded to the sql 2005 format. There's no going back. There is no way to later attach that 2005 database to a 2000 instance without recreating the database end exporting the data. So, it's better to avoid that if possible. I mention this because you may, at some time, want to send a database back to a customer. If that customer has 2000 and you've attached it to 2005, then you will have a problem sending the database back.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[mrdenny]

You can also restore a SQL 2000 backup to a SQL 2005 server (including express).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com