Friday, February 10, 2012

can i keep sql server 2000 if upgrade win 2000 to win 2003 (was "sql server 2000

Hello, i have a question that the sql server 2000 is install in window 2000 server. If i want to update to window 2003. Is that any problem in sql server 2000. I am worry about whether we will have problem after update. What i need to do? Many thanks.Updating operating systems is a bit dodgy. You might want to back everything up, do a fresh install, and restore all the backups.

If you have to do the update, then SQL Server 2000 >SHOULD< run, so long as you have SQL SP3 installed.

Keep in mind, though, you should check with Microsoft before you do this to your really-important-finance database server. Opinions are not guarantees.|||Opinions are not guarantees.
--But, I would lay money down on this one. [:)] If this server is important, I wouldn't even consider upgrading the OS. Backup the files, format the drive, install 2003, install SQL Server, restore the databases.

It takes more time. It's safer. If this is a production server, that's the route I would take.|||i taught that when u upgrade it wipes out the application and writes a new operating system

better back up|||taught or thought??
......nevermind|||does it matter ! think like a good thought !! haa

No comments:

Post a Comment