August 7, 2008 at 8:38 pm
Hi,
few questions regarding system upgrade,
we're planning to upgrade or OS from win 2003 server standard to enterprise edition..
should i worry about my MS SQL 2005 database? (of course beside having a backup of the databases.)
would if affect my databases?
or what to expect with this process?
have anyone experienced this?
thanks..
August 8, 2008 at 6:38 am
Have a backup of all the databases in a safe location before upgrading (just for safety) your Windows server 2003. I hope your database files reside in a different location other than your OS. Just detach all the databases and keep it in a safe location. Upgrade to Enterprise edition and attach the databases.
[font="Verdana"]- Deepak[/font]
August 8, 2008 at 10:17 am
just out of interest why are you upgrading Windows 2003 std to 2003 Enterprise in the first place. I always prefer a clean install for NOS's
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 9, 2008 at 5:59 pm
the management wants it..;p
upgrade will be conducted by our systems engineer.. they just want to know the impact of this activity to database...
well, what could it be? would my database work as usual or might encoulter possible errors?
of course backup will be my priority..
August 10, 2008 at 5:02 pm
There shouldn't be any effect to SQL Server. It's a piece of software running on Windows and it's certified for both versions.
A backup should prevent issues.
Is the server name or IP changing?
August 11, 2008 at 9:05 pm
no ip or server name will be change..
just a plain upgrade of os version..
thanks for your comments and suggestion
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply