| Author |
Topic |
|
fbaker
Starting Member
9 Posts |
 Posted - 2008-02-08 : 13:45:11
|
I am the worlds greatest idiot.  I am very new to SQL Server, so I probably shouldn't have been messing around. But I was trying to find the version number of the SQL Server installed (I was able to pull up all the info on the SQL Server 2005 which we also have installed by clicking on "Change" in the "Add & Remove Programs" and then on the first page clicking the report button, then just cancelling out. When I went to the SQL Server 2000. It only had a "Remove" button. So I was thinking, hey, I should still be able to see it right? I'm so dumb, I clicked on it and now the SQL Server 2000 is gone, and along with it about 6 databases that I spent the last month building. Is there anyway that I can re-install SQL Server 2000 and maybe from our backup disks pull the databases back up? I realize that I screwed up so I welcome any deserved butt chewing. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-08 : 13:52:13
|
| Just to double check , either go to C:\Program Files\Microsoft SQL Server\MSSQL\Data are there any files in there?Also, do a search on your hard drive for *.MDF files , are there any?You can definately, reinstall SQL Server 2000 and reinstall dbs from your backupJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
fbaker
Starting Member
9 Posts |
Posted - 2008-02-08 : 13:58:41
|
| Whew! Yes, there is an .mdf with the name of each of my databases in the C:\Program Files\Microsoft SQL Server\MSSQL\Data folder. So if I re-install the SQL Server 2000 will it notice and find these automatically? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-02-08 : 14:11:50
|
just to be sure copy them and the ldf files to another location first  when you reinstall attach teh databases and you should be ok._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
fbaker
Starting Member
9 Posts |
Posted - 2008-02-08 : 14:22:25
|
| I want to start using SQL Server 2005 Developer Edition. Can I just install the developer edition and then attach the databases, or will it not work since they are different versions and editions? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-02-08 : 14:40:03
|
| it will work_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
fbaker
Starting Member
9 Posts |
Posted - 2008-02-08 : 14:43:47
|
| Sweet. Thanks so much for your help. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-02-08 : 15:39:01
|
quote:
Originally posted by fbaker
I welcome any deserved butt chewing.
try a fetish site, you may have better luck. 
elsasoft.org |
|
|
|
recontrasalo
Starting Member
12 Posts |
Posted - 2008-02-08 : 16:55:04
|
| select @@version |
|
|
|
|
Accedently Removed SQL Server 2000!