Wednesday, March 21, 2012

msde 2000

i have a question concerning scalability. i know i can scale an msde 2000 dayabase to sql server 2000 database. but can i reverse scale an sql server 2000 database down to an msde 2000 database?No, you can upgrade msde to sql server, but you can't downgrade sql server to msde.

The only way you could do this is to uninstall sql server and then install msde.|||reattaching a SQL Server database to MSDE is flawless. (as long as you dont go above the 2gb limit)

but maybe you should test it before you take my word for it.

No comments:

Post a Comment