Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Cannot access Profile database after full SQL restore

  Asked By: Antoinette    Date: Jul 21    Category: Sharepoint    Views: 7305

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.



3 Answers Found

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

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

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

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

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.