| Author |
Topic |
|
phrea84
Starting Member
4 Posts |
 Posted - 2007-07-02 : 11:58:09
|
| HiI am new to sql and we were required to upgrade from SQL 7 to SQL 2005 a few months back due to software upgrades. I thought all went well----SQL 2005 is installed, the software upgrade connected to the database fine, no problems.On Friday I went to load the SQL mmc and it would not load. After poking around and reaseaching, I discovered that SQL 7 is still running (NOT 2005) and when I launch the SQL Management Studio, nothing will load and I get errors.I'm not freaking out yet because SQL is still working, however, I do want to know If I screwed up the upgrade, if it's working fine, or if something else needs to be done.I can post the logs from the upgrade advisor and anything else that may be relevant.Thanks for the help! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-07-02 : 12:15:03
|
| >> I discovered that SQL 7 is still running (NOT 2005)Well if it did upgrade it looks like the upgrade was never tested.Have a look at the services to see if v2005 is there - you must have installed as a named instance (if at all) if v7 is still running.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
phrea84
Starting Member
4 Posts |
Posted - 2007-07-02 : 12:23:06
|
| Well, it shows v 7.0, so I dont know wtf it actually did when I installed it. It's in my program files and add/remove programs. Can someone help me fix this and actually upgrade?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-02 : 14:21:50
|
| How many sql server services did you see in services applet? |
|
|
|
phrea84
Starting Member
4 Posts |
Posted - 2007-07-02 : 16:45:27
|
| 2SQL Server Agent, which is pointed to 7 and MSSQL Server, also pointed to 7 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-03 : 04:45:18
|
| "so I dont know wtf it actually did when I installed it"Client tools only perhaps ?Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-03 : 11:08:45
|
| Looks like you don't have sql2k5 instance on that box at all, I think you just installed sql2k5 client tool. |
|
|
|
phrea84
Starting Member
4 Posts |
Posted - 2007-07-03 : 14:34:14
|
| so whats the best way to achieve my upgrade? Do I just install the full version of SQL 2005 then import from 7? Do I try to upgrade again? Leave it as is?Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-03 : 14:36:03
|
| Install the full version of 2005. Then use either detach/attach method or backup/restore method to move the databases and upgrade them to 2005. You don't need to use the upgrade wizard for 7.0 to 2005. The wizard was only necessary for 6.5 to 7.0 or 6.5 to 2000.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
did i F-up my sql upgrade?