473,803 Members | 3,022 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

REQ:how does one run SQL 2000

I'm trying to install SQL server 2000 inside SBS 2000. Actually I
think I already did it. I just don't know how to run/start it up. I
want to upgrade my SQL 6.5 database backup into 2000.

I have the book SQL Server 2000 Administration by SYBEX.

Here is what I need to know:

The best book on installing SQL 2000 under SBS2000 for a beginner

How to start SQL once its installed

How to upgrade a 6.5 database backup into SQL 2000.

Actually a few good books will accomplish all of this but nothing
beats first hand knowledge from anyone who knows more than me.

TIA
Jul 20 '05 #1
1 1895
kg****@yahoo.co m wrote in message news:<6k******* *************** **********@4ax. com>...
I'm trying to install SQL server 2000 inside SBS 2000. Actually I
think I already did it. I just don't know how to run/start it up. I
want to upgrade my SQL 6.5 database backup into 2000.

I have the book SQL Server 2000 Administration by SYBEX.

Here is what I need to know:

The best book on installing SQL 2000 under SBS2000 for a beginner
There are plenty of books on MSSQL, although I haven't heard of one
relating to SBS specifically. This link may help:

http://vyaskn.tripod.com/sqlbooks.htm
How to start SQL once its installed
NET START, the Services applet in Control Panel, Enterprise Manager,
or the MSSQL Service Manager in the Start menu.
How to upgrade a 6.5 database backup into SQL 2000.
You can't restore a 6.5 backup on a 2000 server, so you can either
upgrade the 6.5 installation in place, or use DTS to copy objects and
data over. Books Online has information on different upgrade options.
Actually a few good books will accomplish all of this but nothing
beats first hand knowledge from anyone who knows more than me.

TIA


Don't forget the Books Online documentation - it's comprehensive, and
full of examples.

Simon
Jul 20 '05 #2

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

Similar topics

4
5130
by: Gleep | last post by:
Hey Guys, I've got a table called Outcomes. With 3 columns and 15 rows 1st col 2nd col 3rdcol outcome date price There are 15 rows for each record, each row accounts for a different type of outcome I'm having trouble with MySQL date comparison. I'm looking for some kind of query that will compare the all date column and only give me the latest date. Then once I have it, ...
9
3213
by: Gleep | last post by:
sorry i didn't explain it correctly before my table is like this example fields: ID name username outcome date1 date2 date3 (etc..) - date15 price1 price2 price3 (etc..) I know that Mysql query order by will compare records on a specific date, but how do i compare multiple fields within the same record. Want to find the latest date within the record..
2
15232
by: Ken Lindner | last post by:
I have a need to become familiar with SQL Server 2000 for work. Needless to say I am new to SQL Server any version, but not IT in general. My employer has provided me with the SQL Server 2000 Personal disk from the SQL Server 2000 Enterprise kit as this is reported here on the MSDN web site to be the version that is supported on Windows XP. In fact so many of you kind people confess to having succeeded in doing it. I have tried...
2
330
by: David Elliott | last post by:
I am trying to format bytes and characters in a hexadecimal format that is preceeded with Zeros. I found some information in the help section "Custom Numeric Format Strings" and "Standard Numeric Format Strings Output Examples" but am unable to get it to work properly. I can print by using the following code byte data; for (int i = 0; i < 30; i++) {
1
6812
by: ido | last post by:
Hi all this is my first post here :) I would like to know something about using javascript programaticaly The thing is i have this web site on which when i press a button i uses a function of javascript.. says exactly this in source <a href="javascript:np('1')" ... now when i am on that page and i type in my browsers comand line (o address field)
2
4253
by: The Whistler | last post by:
I have an app that users can search through a support knowledge base. If a user enters criteria that would cause the app to freeze while it is trying to gather the data, I would like to program a Cancel Query button to either close the command object or close the connection object. This would give the user the ability to cancel the execution and refine the search criteria. I am programming this app using 2005 Beta 2 in VB.net. Any ideas?
4
7305
by: coosa | last post by:
Hi, I was installing SQL Server on my machine and during installation my PC freezed. It happens frequently on my machine. So i tried after restarting to install it again and since then i always get the same error message: "An error occurred while creating one or more registry entries. Please see C:\WINDOWS\sqlstp.log for details. The problem could be caused by a low registry quota condition" I have tried to clean the registry and i...
5
1671
by: zzppallas | last post by:
I have interface A and interface B decalared as follow: class A { public: virtual void OnError(std::string reson) = 0; }; class B { public:
28
95140
by: jens Jensen | last post by:
hello, i'm doing utf-8 encoding the following way. string message; UTF8Encoding utf8 = new UTF8Encoding(); Byte encodedBytes = utf8.GetBytes(message);
0
9564
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10310
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10068
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9121
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7603
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5498
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5627
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4275
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 we have to send another system
3
2970
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.