March 14, 2005 at 3:10 am
Guys.
Need a valuable help form your side? We were using evaluation version of SQL server 2000, which got expired 2day. Unfortunately we don't have any back up... So, if i install a real version of SQL Server on top of it, will it corrupt existing database.. IS there any way to over come this situation with minimal lose of work.
Thanks
Vinu
March 14, 2005 at 10:52 pm
I think that when you shutdown your expired SQL Server, and then copy de database files (including master and msdb), and use these files after installing the full version, you should be able to work on... (Not sure) so be carefull!
Edit: You can use the detach and attach function too.
March 15, 2005 at 1:12 am
The above should work - stop the eval edition services, copy the .mdf & .ldf files to a different location. Do the new install, stop the SQL Services, copy the saved files in on top. Make sure you install to the same disk and directory structure as you had before.
March 15, 2005 at 9:40 am
March 15, 2005 at 11:30 am
I just encountered this type of issue in 'beta' SQL 2K5 admin training a couple of weeks ago. The 'eval' version expired on morning 2 of a 3 day course. We worked around this by resetting the computer BIOS date back 30 days and rebooting (you could also use the GUI, but the reboot is needed). If this works method works for you in your situation you'll be able to backup and/or detach your databases b efore the upgrade.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply