Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
astralis
Yak Posting Veteran
62 Posts |
 Posted - 2007-01-17 : 16:42:42
|
| I was expecting a warning but I turned on my computer and discovered that MSSQL Server 2000 eval. has expired. At this time, and in the foreseeable future, I cannot afford a retail version. But I would like to upgrade to MSSQL Server 2005 Express.Have I lost all my data? What can I do? |
|
|
agossage
Starting Member
9 Posts |
Posted - 2007-01-17 : 17:21:09
|
| This process may work with 2000 eval. I have done this from 8.0.2039 to 9.0.1399.Make a backup of your data folder.Install SQL Server 2005 Express with the Management Studio.Copy the files (MDF,NDF,LDF) to the new data folder (i.e. MSSQL.1)In SQL Management Studio, attach the MDF files one at a time.They may attach as (In Recovery), just give it some time and refresh.Adam GossageLake Wylie, SC, USA |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-17 : 17:22:41
|
| Just make sure you stop the MSSQLSERVER or MSSQL$InstanceName service prior to doing what Adam says, if it's started that is. This releases the files from SQL Server so that they can be copied then attached to another server.Tara Kizer |
|
|
|
astralis
Yak Posting Veteran
62 Posts |
Posted - 2007-01-17 : 17:25:28
|
| Thank you! I'll follow your advice. |
|
|
|
agossage
Starting Member
9 Posts |
Posted - 2007-01-17 : 17:27:59
|
| Oh yeah, that's a show stopping step NOT to leave out. It's late in the day. My apologies.Adam GossageLake Wylie, SC, USA |
|
|
|
astralis
Yak Posting Veteran
62 Posts |
Posted - 2007-01-17 : 23:43:04
|
| It worked perfectly. Thank you for the help! |
|
|
|
|
|
|
MSSQL Server 2000 eval. expired!