Solved

General question regarding SQL Server 2000

Posted on 2009-04-09
2
207 Views
Last Modified: 2012-05-06
our network contains various applications tht use ms sql 2000 databases. the previous network admin had set up multiple sql servers on various servers. We wish to centralize all the databases and on one sql server adn as well as upgrade it to the latest versiono of sql server. what are the various factors that we need to consider before taking this step?

Please and thansk

0
Comment
Question by:ashjuv
2 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 24108313
First, you have to consider that your server must be powerful enough to host all of the databases you plan to put on it.  Maybe the dbs were on other servers for processing power purposes.  Also, you'll need to change all of your application connection strings to point to the new server.  Also, you'll need to decide whether you want to take these databases down and move them, or to keep them running and resotre backups.  Either way, you're going to have a little bit of downtime.
0
 
LVL 7

Expert Comment

by:ruscomp
ID: 24108394
Also, just as a side note, you stated that you wanted to upgrade them all to the latest version... even if they are all updated, you can run each database under a different compatibility mode, so if an issue arises, you can set the compatibility mode to 2000 for that specific database (but should only be a quick fix, not a permanent solution).
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled taskā€¦
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question