Re: Restore Content Database problem

I found that by having the exact same security as I did before hand
that it now works. The new server was not put onto a domain but once it
was everything worked fine. Does anyone know if you can make it work
without the same security setings?
Ricko wrote:
Sorry,

I just replied to my original topic and can see it about but not sure
why you wouldn't..

Here is my post again

Hi,

I have spent basically the whole day reading about restoring the
content database in WSS but I still can't seem to get it working. I
really hope someone can help me out..


The only backup I have is the content database (SQL 2000 backup) but
not the configuration database.


The steps I've done so far are on a new server are:
1. Restored the database into sql
2. Installed WSS with remotesql=yes and server farm option
3. Run through the first central admin setup pages choosing an
application pool with identity of the local admin account. This also
created a new configuration database.
4. Created a new web site in IIS
5. Extended this site in WSS
6. Removed the newly created content database via 'Manage content
databases ' in central administration
7. Added my restored content database as the new content database -
once I did this I can see that Current Number of Sites = 1
8. Added the local admin account as a security and process admin and
database creator role of my restored content database.


When I browse to the site I get 'Cannot complete this action'


Firstly is there something I have missed? Do I need the original
configuration database?


I've also run exec sp_changedbowner 'server\Administrator' but it says
The proposed new database owner is already a user in the database so it

must of been using the same user as I am using now, I couldn't check
this because the old server crashed and the only backup I have is the
content db.


Does anyone have any idea what I might of done wrong?


Thanks, Rick




Todd Klindt [MVP] wrote:
You didn't quote the original problem with this request for help, so I have
no idea whether I can help you or not.

tk
"Ricko" <rdemarco@xxxxxxxxxxxxx> wrote in message
news:1158028162.122273.58020@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
So nobody can help me with this? I have successfully restored a backup
from a test content database but the main difference here is that I
restored it to the same server that I backed it up from so all security
etc was the same.

I'm thinking that it may be related to the new server that I am
restoring to may have slightly different security - app pool identity,
sql accounts. Does the security need to be identical for this restore
process to work?

Thanks, Rick


.

Relevant Pages

  • Re: number of critical errors occurred on SBS 2003
    ... SharePoint 3 has been around for a while for SBS, and if it were installing with the database security defaulting to an incorrect setting, that would be well known by now. ... I would check all the installation docs and the release notes, but I would assume the security is correct unless you find written documentation to the contrary. ... mode of the SQL Server in regards to event ID: ...
    (microsoft.public.windows.server.sbs)
  • Re: SceCli Error 1202 filling up the Event Log!
    ... > after restarting the Win2003 server, the secedit.sdb database does not get ... >>> security database and have it recreated. ... >>> configuration\windows settings\security settings, you should inventory ...
    (microsoft.public.win2000.advanced_server)
  • RE: Script for find dominos users
    ... The key lies in the fact that Domino web servers will ... "404" nonexistent URI if the database does not. ... Choose not to allow email through the web (Application Security, ... server's server document. ...
    (Bugtraq)
  • Re: Newbie Salt and Pass Phrase Question.
    ... is it a server side application? ... The database contains private ... The second biggest problem confronting me is that security was ... My client, a tennis coach, tells me other coaches at the same ...
    (sci.crypt)
  • Re: Is this possible??
    ... The OwnerAccess option is used with user level security - which is only ... the application from the beginning using client/server concepts such as ... You would keep the back end database on the server where only ...
    (microsoft.public.access.tablesdbdesign)