Moving back to MSDE 2000 after removing SQLServer 2005 Express

Apparently you cannot go backwards. Once 2005 Express is installed, even removing it does not allow you to setup MSDE 2000 again. So there is no "trying it out" option.

Unfortunately, our software does not use 2005 Express. I tried it out, and now have a useless testing workstation that can't have MSDE 2000 installed again.

Any ideas on how to break the chain here are welcome.

Hi,

If the workstation is just for testing, can you not just rebuild it?

Failing that have you tried removing all of the SQL Server registry keys/values before trying MSDE 2000 reinstall?

Regards,

Gary.

sql

Moving back to MSDE 2000 after removing SQLServer 2005 Express

Apparently you cannot go backwards. Once 2005 Express is installed, even removing it does not allow you to setup MSDE 2000 again. So there is no "trying it out" option.

Unfortunately, our software does not use 2005 Express. I tried it out, and now have a useless testing workstation that can't have MSDE 2000 installed again.

Any ideas on how to break the chain here are welcome.

Hi,

If the workstation is just for testing, can you not just rebuild it?

Failing that have you tried removing all of the SQL Server registry keys/values before trying MSDE 2000 reinstall?

Regards,

Gary.

Move distribution database to another drive?

Is it possible to move a distribution database to another drive without removing replication? I have done some research but I getting mixed answers from Google searches.

Thanks in advance

Dave

I don't know the specifics, but I believe it involves creating a new "data file" on the new drive, then telling SQL Server to decommission the original, moving data to the new file as it goes.

-Ryan / Kardax

|||

Have you tried looking in Books Online before google pages?

ALTER DATABASE...MODIFY FILE should work.

Move distribution data/log files to another drive

I haven't found the definitive answer on how or if this can be done without removing replication. I'm thinking ALTER DATABASE modify_file is the way to go. Anybody know if this will work or a better way to go about it?

Thanks

"Alter database" should work. There is a similar posting.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1619608&SiteID=1

Gary

|||I saw that one. The client ended up adding a file to the new drive and shrinking the original.

Thanks