Post reply

Reinstall SQL Server 7.0 SP3

  • October 28, 2002 at 10:02 am

    #58049

    Please Help....!

    It all went wrong about a week ago when we upgraded our server to MDAC 2.7 from 2.5 sp1. First of all our DTS would no longer run a scheduled task. We tried to figure out why and attempted to fix it but realised that we should rollback to the previous version because it was very important for us to have these working. So we found a method of rolling back which actually worked and our DTS worked again! But since then, more problems. Our backups wont work due to a problem with the registry (??) and our nightly load jobs fail because they keep "receiving unknown tokens from sql server" (??). These two errors have only happended since rolling back the MDAC version and now we believe its totally ruined the server!! So we are going to reinstall SQL Server and hope that this will sort it back to what it was.

    My question is..... how do I go about reinstalling it without loosing the data, logins, sp's etc. I was thinking about using sp_dettach on all the databases (including master, model and msdb), uninstalling the software, reinstalling the software, attaching all the databases again. Then finally adding sp3. DO you have any advise and do you think this is a good plan?

    Thanks, Meg

  • October 28, 2002 at 11:55 am

    #439628

    Do you have a backup of the registry? That would also help.

    If you can't make backup so I think that you can try dettaching the dbs. Do you have the DTS jobs saved to a file?

  • October 29, 2002 at 2:14 am

    #439682

    yes, we have all the dts jobs saved in files. I think we are gonna just go for it today, we have a back up of the server which we can use if messes things up even more.

  • October 29, 2002 at 5:51 pm

    #439764

    If you can't backup the databases ten you should attach them once you reinstall sql. After that open the DTS packages from the files.

  • October 30, 2002 at 2:36 am

    #439777

    Oh no! We've done the reinstall of SQL Server and attached the databases back to it. Unfortunately we still have the same problems. Does anyone know where the error "Unknown token received from sql server" comes from? Our nightly load will not run because of this error which occurs in most of the jobs. Thanks.

    Meg

  • December 10, 2002 at 1:45 pm

    #443981

    I'm having the same issues, I jumped on the MS site, KB#176256 try this...

  • December 10, 2002 at 4:49 pm

    #444011

    If the problem started with MDAC 2.7 you will need to reinstall OS to revision back to 2.5 sp1 then SQL and the databases. Have you test on another server to confirm is related to MDAC 2.7?

    ALso, what does your DTS package do, reference and have you tried redoing the connections you may have made inside the packages to see if will correct?

    If you want to try and actually uninstall MDAC 2.7 check out thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8655&FORUM_ID=48&CAT_ID=1&Topic_Title=How%20uninstalling%20MDAC%202.7&Forum_Title=Service%20Packs for a bit of help. As you will have to reinstall OS it may be worth a try first but I would be very concered if this is a production DB since could potentially leave other issues behind.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply