Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Cannot access Profile database after full SQL restore

Asked By: Antoinette Cross Date: Jul 21, 2007 Category: Sharepoint Views: 610

I wonder if anyone can help here. We had a major server failure last
week where we lost our data server. The server running Sharepoint IIS
was unaffected but we lost the SQL databases (Prof, Serv, Site,
Config). We restored this using SQL and SharePoint was back up and
running. However, although users can log on and access their data
there are some things that are not working. For instance, I cannot
access the Profile database, or Search Scopes. Also, the incremental
crawls and audoence compilations are just running and not stopping,
but not reporting any errors. When I attempt to access the profile
database via Site Settings it just hangs rather then report an error.

Running SPS 2003.

Any ideas would be very much appreciated.

Tagged:cannot access profile database after full sql restore

3 Answers Found

Answer #1 Answered By: Vinay Thakur Answered On: Jul 21, 2007

There are a few things you can check. Can the _PROF database be
accessed via SQl Manager? Is the database owner the Sharepoint
service account (same as other two databases)? Does that account
still have DBCreator and Security Admin roles? If the SQL instance
has had BUILTIN\Administrators removed the account will also need
System Admin rights (sa).

You might also run DBCC CHECKDB to verify the database restore was
not corrupted.

You didn't say if SQL was 2000 or 2005. There is an issue with 2005
that causes the crawls to run continuously. Check here
http://support.microsoft.com/kb/930887/en-us

Answer #2 Answered By: Christen Roberson Answered On: Jul 21, 2007

The db owner (our
sys admin account in this case) had access to all 3 DBs. Looking at
that User in SQL Enterprise Mgr though the account did not seem to
have the relevant permissions (ie. permission to do everything
basically). Anyway, I manually added the permissions and it made no
difference. However, I then rebooted the server and it is now working.
I have a horrible feeling that that was what I needed to do all along
(how embarrassing).

Answer #3 Answered By: Faith Delgado Answered On: Jul 21, 2007

You need to restore the index and the databases to the same point in
time. I would use the SharePoint restore tool to restore both the
databases and the index. I suspect that the index and the databases are
out of synch.

Didn't find what you were looking for? Find more on Cannot access Profile database after full SQL restore Or get search suggestion and latest updates.