Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2008-04-07 : 08:53:00
|
| We had a disaster last week (SAN Corruption) and it hit a bunch of my sql serves.I have been able to recover all but one. The one I am having a problem with is a NAMED Instance that I obviously don't know the original SP level on. When I try to restore MSDB it won't let me because of a version conflictIs there any way to tell what the SP Level is either from a system DB .mdf or LDF file or from a backup file without restoreing? Right now I'm installing SQL Server to a test server and I'm going to try and restore the system dbs at each patch level.. seems like there must be a better way!! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-07 : 09:35:38
|
| Are you able to restore others system database though? |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-04-07 : 10:05:50
|
| you can find the SQL Version by using RESTORE HEADERONLY.-ec |
|
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-04-07 : 10:15:54
|
Thanks. my build is 760 which is sp3 :( Is there a way to uninstall sp4 without reinstalling?????? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-04-07 : 10:16:49
|
quote:
Originally posted by jpotucek
Thanks. my build is 760 which is sp3 :(Is there a way to uninstall sp4 without reinstalling??????
no. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-04-10 : 16:07:53
|
| Can you have multiple instances of SQL at different SP levels? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-04-10 : 17:08:18
|
quote:
Originally posted by tripodal
Can you have multiple instances of SQL at different SP levels?
yes, but the client tools will be patched at one level if you have them installed on the same server. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-04-10 : 17:57:58
|
| "client tools" such as the Enterprise manager?So install sql 2000 sp3 in another instance, and connect to it remotely from your workstation with sp3 EM installed. Then get your database into sql2000 sp4. Which you will need to do sooner or later. |
|
|
|
|
|
|
sql server 2000 ent edition sp level?