OS Upgrade NT to W2K

MS SQL SERVER

    Sponsored Links

    Next

  • 1. How to configure SQL server to use multiple processor
    hi, We have a system with two processors. What settings should we do in sql server 2000 standard edition to use both the processors. Can anyone suggest? Thanks Prem
  • 2. 3GB Switch question
    I am using the following: Windows 2003 Enterprise SQL 2000 Std SP3 6GB Ram 4 CPU's with HT turned on (3.2) I will be running multiple instances of DB. What should the entry in boot.ini be to best utilise the resources. Thanks.
  • 3. 4GB Ram and any switches in BOOT.INI
    Just installing SQL Ent 2005 on 2003 Standard server R2. Have 4GB ram in the server. Do I need the 3GB switch or not?
  • 4. Running remote queries with SQL Server Express Manager?
    Hi, I'm installing newsletter software for a friend that requires queries to be run against her web host's MS SQL database to build tables. Can SQL Server Express manager run quires against a remote database like this? If not, can someone please recommend a tool to accomplish this that's inexpensive or that includes a free trial? Thank you very much, bill
  • 5. SQL 2005 Capacity planning
    Hi, colleagues, i need your advice! Is there tools, or documents that can help me in capacity planning and server sizing for SQL 2005. I have found the same post on microsoft technet forum, and there were link to "Administrator`s companion" ebook. I have read it and there is no planning SQL capacity depending on numbers of users and size of databases. I need to plan my deploying, so i need to get hardware requirements for servers before i will setup SQL server software.

OS Upgrade NT to W2K

Postby David Knapp » Fri, 17 Oct 2003 23:43:21 GMT

We would like to upgrade our SQL server OS from NT 4.0 to 
W2K.  Our network guys want to do a C: drive disk wipe and 
clean OS install instead of an in-place.  How can I best 
save our existing SQL2K(SP3) installation so I can restore 
everything to the way it was prior to the disk wipe?  I 
know I need good backups of the user DBs.  I will be re-
installing SQL2K and service packing it before I restore 
any user DBs.  What do I need to do to get the security 
settings/users/jobs and master DB back?  Any other items I 
need to restore.  No replication or log shipping going 
on.  Is there a script that will do the majority of the 
work?  Thanks for any info.

Re: OS Upgrade NT to W2K

Postby Keith Kratochvil » Sat, 18 Oct 2003 04:57:35 GMT

Restoring master should get your security back up and running.  You can also use something like this:  http://www.**--****.com/ ;EN-US;q246133

Restoring the msdb database will get your jobs back.  Of course you want to backup and restore the user databases as well.

Backup and is very well documented within Books Online.  Make sure that you read the section regarding restoring the master database.  This is the tricky one, as SQL Server has to be started in single user mode at the command prompt.

-- 
Keith





Similar Threads:

1.Upgrading OS from W2K to 2003 Server

When I run the 2003 server compatibility report on my W2K server running SQL 
2000 the report is showing SQL server 6.5. Yet when I ran select @@version 
in Query Analyzer it is showing SQL 2000. I don't feel comfortable upgrading 
the server OS to 2003 until I find out why my SQL is showing as SQL server 
6.5 instead of 2000. I am afraid it will disable my SQL server. Any ideas 
why and how to resolve the issue. 

Looking forward any ideas or solution on how to fix the issue. 

Ismael

2.Merge Replication NT W2K

Hi there,

I am implementing a merge replication
NT Publisher and Distributor
W2k Subscribers
Fails when the subscriber tries to retrieve data from the 
distributor.  However It says that it cannot find the 
distributor.
But the distributor is registered on the subscribers 
enterprise manager and viceversa.
The replication job fails but both distributor and 
subscriber are in the same domain.
And I am using a domain account to start services.
Thanks.

3.NT4 cluster upgrade to W2k or WS03 cluster

I have one NT4 cluster with active/active SQL7  on it.  I 
want to upgrade the Windows to W2k orWS03.  Eventually the 
SQL7 will be upgraded to SQL2000 as well.  Is it possible 
to do a rolling upgrade safely, and if so what's the 
strategy ?  I have seen several articles about rolling 
upgrades but not with SQL7.


4.SQL 2000 + W2K Upgrade

I have an HP Proliant DL380 clustered server running SQL2000 and W2K with a 
mirrored array.  I need to reconfigure the array to change the relative 
sizes of data drives; backup drives; quorum drives, etc. AND upgrade to 
W2003R2 and SQL 2005.  Any suggestions on the order of how to proceed?  I 
was thinking at first of an in-place upgrade but with the reallocation of 
the space on my drive volumes this won't be possible.  Will SQL2005 be able 
to do a restore from a SQL2000 Backup??  What's the best approach? 


5.search problem after upgrade from SQL2000 SP3 / w2k to SQL2000 SP4 / w2k3

6. Upgrading to W2K with SQL 6.5

7. Upgrade W2K SP4 to W2K3 SP1 and SQL server 2000 SP3

8. Connection error to SQL server 2005 from NT OS via ODBC



Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 55 guest