473,463 Members | 1,528 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Moving a database between two SQL Server with different patch levels

Hi,

I need to move a database from an instance running SQL Server 2000 SP3
to another running SQL Server 2000 SP2. Can I just use backup/restore
or detach/reattach and let SQL server take care of any downgrading (if
any).

Many thanks
Giovanni
Jul 20 '05 #1
4 1822
Hi

I doubt if you can downgrade like this, and you may get spurious results. A
safer option may be to use the transfer wizard.

John

"Giovanni" <gi**************@lstrillium.com> wrote in message
news:36**************************@posting.google.c om...
Hi,

I need to move a database from an instance running SQL Server 2000 SP3
to another running SQL Server 2000 SP2. Can I just use backup/restore
or detach/reattach and let SQL server take care of any downgrading (if
any).

Many thanks
Giovanni

Jul 20 '05 #2
Giovanni (gi**************@lstrillium.com) writes:
I need to move a database from an instance running SQL Server 2000 SP3
to another running SQL Server 2000 SP2. Can I just use backup/restore
or detach/reattach and let SQL server take care of any downgrading (if
any).


No. You will have to rebuild the database from scripts and bulk data in
or out. Or use the Transfer Wizard that John mentioned.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #3

"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...
Giovanni (gi**************@lstrillium.com) writes:
I need to move a database from an instance running SQL Server 2000 SP3
to another running SQL Server 2000 SP2. Can I just use backup/restore
or detach/reattach and let SQL server take care of any downgrading (if
any).
No. You will have to rebuild the database from scripts and bulk data in
or out. Or use the Transfer Wizard that John mentioned.


You positive? Generally SP's only modify system databases. This is one of
those cases I'd suggest "try it, expect it to fail, but you may get lucky."


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #4
Greg D. Moore (Strider) (mo****************@greenms.com) writes:
You positive? Generally SP's only modify system databases. This is one
of those cases I'd suggest "try it, expect it to fail, but you may get
lucky."


And they you later run into problems, and then you find out that is not
supported. Better safe than sorry, as they say.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #5

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

Similar topics

1
by: Mark Dengler | last post by:
I am trying to write a C# backend program that will handle the database maintenance that I would otherwise have to do via Microsoft's Analysis Services front end GUI Wizards. Currently I am having...
7
by: aaj | last post by:
Hi all Would anyone be able to offer any unbiased thoughts or advice on reasons to switch to .Net. I have read some of the literature and read other stuff on google, but a so much of it seems to...
3
by: Daves | last post by:
why the heck can't I use Directory.Move() to rename a directory (containing files) to a entry 2 levels below e.g. uploads/tempfiles -> uploads/tempfiles/48/003files if I do this in one line...
1
by: GTi | last post by:
In MS SQL you can create a database that is run in a seperate instance. Why and when should a database run on a seperate instance ? Benefits ? What is prefered and why? Two applications have...
17
by: romixnews | last post by:
Hi, I'm facing the problem of analyzing a memory allocation dynamic and object creation dynamics of a very big C++ application with a goal of optimizing its performance and eventually also...
18
by: surfrat_ | last post by:
Hi, I am having the following problems in getting Microsoft Visual Studio 2005 Professional to link to an Access .mdb database. Please help me to sort this out. Problem 1: The Microsoft...
14
by: Mikee Freedom | last post by:
Good Morning all, New member to the list, hoping you might be able to give me some much needed advice. Basically, I have a client who would like to offer the ability for his users to have...
3
by: ukrutter | last post by:
Any help would be greatfully recieved here! I'll try and explain the situation here... I have a database in Access, which is in essence a booking system. I am using VB6 to link to this database....
3
by: Larry Leonard | last post by:
Running MSDE 2000 SP2 on Windows XP SP3. I have a T-SQL script that is relatively simple (adding constraints, inserting rows, etc.) and short (maybe 300 lines, heavily commented). It's an...
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...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

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.