SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 rebuilt the instance		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

aki123
Starting Member

20 Posts
Posted - 08/28/2007 :  07:19:21  Show Profile  Reply with Quote
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 - 08/28/2007 :  08:42:59  Show Profile  Reply with Quote
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
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts
Posted - 08/28/2007 :  21:05:39  Show Profile  Reply with Quote
You can't restore sql2k's system dbs to sql2k5.
Go to Top of Page

aki123
Starting Member

20 Posts
Posted - 08/30/2007 :  01:35:00  Show Profile  Reply with Quote
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
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts
Posted - 08/30/2007 :  01:57:17  Show Profile  Reply with Quote
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?
Go to Top of Page

aki123
Starting Member

20 Posts
Posted - 08/30/2007 :  04:25:18  Show Profile  Reply with Quote
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
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts
Posted - 08/30/2007 :  21:35:26  Show Profile  Reply with Quote
If you don't know which file to work with, you can start sql in single user mode in services applet.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000