473,396 Members | 1,864 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,396 software developers and data experts.

restore a SQL2000 db to a SQL7.0 server

How to restore a database dump file (.BAK) that backed up from SQL
2000 server to a SQL 7.0 server?
Please help.
Saiyou
Jul 20 '05 #1
1 2168
As far as I know you cannot do this, you can only do it the other way
around.
Obviously, you could connect the dbs and transfer objects

JV
__________________________________________________ ________________
Remotely manage MS SQL db with SQLdirector -
www.ciquery.com/tools/sqldirector/

"Saiyou Anh" <wa***@alexian.net> wrote in message
news:a5**************************@posting.google.c om...
How to restore a database dump file (.BAK) that backed up from SQL
2000 server to a SQL 7.0 server?
Please help.
Saiyou

Jul 20 '05 #2

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

Similar topics

0
by: Dave | last post by:
I have a client that requires me to back up his sql7 db to my server and restore it in sql200, then restore it so they can run from my server if disaster hits his server. I have a batch file...
1
by: Rene | last post by:
Hi, While restoring the log we receive a message after about 30 minutes: Processed 1152109 pages for database 'restest', file 'sales_Log' on file 1 Server: Msg 9004, Leverl 21, State 20, Line...
1
by: LizP | last post by:
Hi, guys - looking for a bit of help/advice on moving a database from SQL 7 to SQL 2000. We've a third party application which currently uses a SQL7 database. This database has a number of views...
9
by: Dave | last post by:
When I am trying to use backup or restore from the EM, a dialog box never pops up, and the EM interface locks up. Has anyone else had problems like this? Looks like all other functions from EM...
0
by: xo55ox | last post by:
Hi, I have been trying to set up an automated restore process from prod to backup server. First, I schedule the full database backup nightly, transfer the backup file and restore it to the...
4
by: xo55ox | last post by:
Hi, Currently, I am on SQL2000 SP3 and Windows 2003. I am trying to restore the full database backup and transaction log backup on the development server. The full database restore is not a...
3
by: butatista | last post by:
Please help SQL Server 2000 Standard I am trying to restore databases on my server and am unable to get them to restore using the database option. For example, the location of my backup...
5
by: sarahlin | last post by:
Hi there, we tried to restore a sql 7 DB to sql2000, somehow some of the varchar filed become nvarchar, why is this? thanks, -sarah
0
by: @sh | last post by:
Guys, we want to use the Replication features (or something similar) to backup our primary SQL database, the primary DB is using SQL 7 and our secondary server is SQL 2000 - is this possible? ...
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
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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
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
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,...

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.