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 |
|
jstormoen
Starting Member
30 Posts |
 Posted - 2006-10-10 : 10:11:14
|
| Here is the scenario we are rebuilding a SQL server and the version was at 8.00.818 but I cannot get to that particular build. If I don't I cannot find a way to restore the Master DB from backup ? Any ideas ? I have tried applying the password patch and ms-031 patches but that still did not get me there ???? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-10-10 : 10:37:04
|
| search forsql server 8.00.818in google.==========================================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. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-10 : 10:39:07
|
| sp3a + 818 hotfix--------------------keeping it simple... |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-10 : 10:47:13
|
| 818 corresponds to ms03-031 security hotfix (http://support.microsoft.com/kb/821277/). It seems like you tried to install that already, but I am wondering if you installed SQL Sp3a first. MS03-031 requires that SP3a already be installed before you can apply the hotfix.-ec |
|
|
|
jstormoen
Starting Member
30 Posts |
Posted - 2006-10-10 : 12:25:57
|
| Yes I did install that but after a full uninstall and reinstall using Enterprise version - I was able to get it up to version 818 and restore the Master as I needed to.Thanks |
|
|
|
|
|
|
rebuild of SQL server - Help