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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-02 : 08:03:45
|
| Denis writes "we have a sql 2000 svr sp3 running Windows 2003 built datbases on an eval version now we have a full version databases are not connecting to the new install and seem to be resetting.. the database seems to be attached to a security fileis there a way to reconnect?thanks in advance" |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-12-02 : 11:36:40
|
| Huh?Let me see if I have this right. You built a server with a SQL 2000 Eval edition. Then you built a server or installed a different (named?) instance with a non-eval version? Here I assume you brought the eval databases over to the new instance of SQL Server, but just confirm, if you can.And now the regular version is resetting itself at random?What is listed in the SQL Server errorlog (errorlog.1 will be most interesting, since it is the one leading up to the reset). |
 |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-12-02 : 14:43:09
|
quote:
Originally posted by mcrowley
it is the one leading up to the reset.
I don't think he is referring to the server hardware /OS "resetting". I think he means that they are able to get the DB's onto the new server but then they disappear. It all sounds strange to me and I'm not sure this question gives enough to go on.Denis,The security info is stored in the master database. I'm not sure if you can bring that over to SQL Standard or Enterprise from an Eval version. I'd think that it would not work. The databases themselves can be moved via backup & recovery or detattach & attach.Daniel, MCP, A+SQL Server DBAwww.dallasteam.com |
|
|
|
|
|
|
sql 2000 resetting