November 13, 2007 at 1:31 pm
Hello all,
I am a newbie to SQL and inherited SQL2000 a few months back. The HDs in the server were degraded and crashed before a good backup was performed.
I replaced the HDs and restored from the latest BU I could, I then found out about Data Maintance Plans - which gave me a more update backup.
Since then - I have struggled with SQL and creating new maintenance plans (the full securities didn't copy over from backup). Logs are too big, the order I have them is not correct.
I am drained from SQL2000 - I just took a 35 hour course only to learn what I already learned in panic mode when the server crashed. Now I have been told by my executives to upgrade from 2000 to 2005 - we are keeping our existing 32bit server.
Any good - "great detailed links" to help me with this upgrade would be greatly appreciated. I am a one man team and I don't have time for servers/software to break down :w00t:
Thanks for any suggestions!
November 13, 2007 at 3:09 pm
a good starting point is to load up the sql 2005 upgrade adviser. This can point out problems that can occur so you can fix them in advance to your upgrade
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply