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.
TIAkg7poe@.yahoo.com wrote in message news:<6kkv90lpc9o1o50pv16ispl5n0e86j9cnm@.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
No comments:
Post a Comment