473,385 Members | 1,934 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Installing SQLServer2005 but Preserve Current SQLServer2000

I have a default installation of SQLServer2000 on a host running
Win2003. I want to install SQLServer2005 on the same machine, but
preserve the original SQLServer2000 installation. How do I do this --
install into new directory? new directory and named instance? just
new named instance? What stumbling blocks could I run into?

Oct 1 '06 #1
2 1442
re********@yahoo.com wrote:
I have a default installation of SQLServer2000 on a host running
Win2003. I want to install SQLServer2005 on the same machine, but
preserve the original SQLServer2000 installation. How do I do this --
install into new directory? new directory and named instance? just
new named instance? What stumbling blocks could I run into?
I believe new directory and named instance is necessary and sufficient.
Oct 1 '06 #2
2005 will work side-by-side with 2000 as a named instance. Just note
that there is no Microsoft tool to migrate a database back to 2000.

You will want to set a different data/backups folder - e.g. \mssql2005.

* * * * * * * * * * * * * * * * * * * * * *

re********@yahoo.com wrote:
I have a default installation of SQLServer2000 on a host running
Win2003. I want to install SQLServer2005 on the same machine, but
preserve the original SQLServer2000 installation. How do I do this --
install into new directory? new directory and named instance? just
new named instance? What stumbling blocks could I run into?
Oct 2 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Kees Pijnenburg | last post by:
Hi all, I've been reading through the lasts months of postings in this (and some other) newsgroups to find a solution to my PHP problem. The configuration I use is as follows: - SuSE v8.2...
8
by: hb | last post by:
Hi, I need to declare a variable who's value can be preserve through the same ASP.Net page. I tried the following code, only the static variable s2 keeps its value=22 after lnk1_Click followed...
0
by: Michael Peters | last post by:
(sorry for crossposting, I usually don't but I need a solution quickly) is there a simple way to remotely and programmatically (using a ColdFusion application that can access the database) making...
0
by: thegoogs | last post by:
Hi, I have a question about users, logins and permissions in SQLServer2000... I have to list every user in a SQLServer, extract which database it can access and which permissions it has for every...
1
by: vijaykumars | last post by:
+-----------------------------------------------------------------------------+ Summaries: +-----------------------------------------------------------------------------+ Installation...
4
by: Mark Olbert | last post by:
I'm looking for help in getting the Transfer Sql Server Objects task to work. The goal is to transfer the tables, views, sprocs, udfs from a SqlServer 2000 database to a Sql Server 2005 database. ...
1
by: ShivBahadur | last post by:
Hi All, how to remove "tempdb is full error in sqlserver2000"
7
by: Adrian | last post by:
Hi, I'm trying to add caching to our asp app, but am having problems with the SQLCacheDependancy not invalidating the cache when the table changes. Using vs2008, sqlserver 2005 developer edition....
3
by: =?Utf-8?B?QWxoYW1icmEgRWlkb3MgRGVzYXJyb2xsbw==?= | last post by:
Hi misters, I continue installing; my production PC is Windows 2003 I need copy dll (C runtime DLL msvcr71.dll) to windows\system32 directory if not installed yet. I want create Setup...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.