rebuilt the instance - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

rebuilt the instance

Author

Topic

aki123
Starting Member

20 Posts

Posted - 2007-08-28 : 07:19:21

hi

i restore my 2000 server on another machine
in a lab invironment
i use sql 2005 express on it
i need to restore the database from backup devices i have
yet this instance cannot be started.
beacuse it cannot connect to the db.

till now i used to re-installed the instance
or install a new one and restore db on it.

is there is a simple way?

thanks

aki123
Starting Member

20 Posts

Posted - 2007-08-28 : 08:42:59

me again

when tring to restore the master db of this instance
i get : your sql server installation is either
corrupt or has been tampered with ...

thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-28 : 21:05:39

You can't restore sql2k's system dbs to sql2k5.

aki123
Starting Member

20 Posts

Posted - 2007-08-30 : 01:35:00

hi ramio

when i restore my member server on another machine
i get to un solved issue:

1. i cant access the instance i used,
beacuse the database is no longer in the folder.
so i need to create another instance.
is there is a way taht i can repair the same instance?

2. is there is an order in restoring the system of the instance db.
beacuse when i restore the master using single user
then the service wont start.

thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-30 : 01:57:17

1. If system db files are not there, not much you can do.

2. Should restore master first then model and msdb. Did you get any error when try to start sql?

aki123
Starting Member

20 Posts

Posted - 2007-08-30 : 04:25:18

hi ramio

since my last post, i reinstall and install
the instances about 10 times.

it seems that my restore to the master was not good.
dont know if that is the case and dont understand why,
but just when i excutes the cmd of single user mode
from sql.1\binn and not from sql.2\binn

i thought i should use the instance exe file.

thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-30 : 21:35:26

If you don't know which file to work with, you can start sql in single user mode in services applet.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources