Please Help: How to restore sharepoint database

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kevin Egan (noemail_at_here.pls)
Date: 07/18/04 

Date: Sun, 18 Jul 2004 19:39:22 -0400

Another admin removed the MSDE instance of sharepoint from the server
yesterday and I've been trying to recover it. I had upgraded the instance
to SQL and it was running fine. I set up a backup of the configuration and
content databases using the SQL backup tools so I have recent backups. In
an attempt to recover, I tried to re-install the Intranet component but that
didn't replace the MSSQL$Sharepoint service instance. I had to remove the
Intranet component and then re-install it.

I'm not SQL/MSDE expert so I may have the process wrong but now I don't seem
to be able to recover the databases. If I restore the databases from
Enterprise manager, I am not able to connect to them from Sharepoint Central
Admin -- there are no databases listed in manage content databases. If I
try to create a new database from Central Admin, it says one already exists.

How can I recover the databases?

Thanks.

Relevant Pages

  • Restore sharepoint site
    ... yesterday and I've been trying to recover it. ... content databases using the SQL backup tools so I have recent backups. ... Admin -- there are no databases listed in manage content databases. ...
    (microsoft.public.windows.server.sbs)
  • Recover historic databases
    ... To prevent disaster recovery I do backups every day and it works fine, ... want to archive historic databases to recover it if necessary. ... version of SQL server. ...
    (microsoft.public.sqlserver.security)
  • Dead Portal
    ... An old admin that didn't know anything about SPS ... deleted the databases for a portal in SQL and now I have a "dead portal" in ... I'm using a SQL 2000 SP4 backend located on a different server than SPS. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Crash recovery
    ... repair is the only option ONLY IF normal recovery (after you fixed ... You should first try to recover the database using normal recovery after you ... done with the databases in the same path location as original! ... > extract the data from one store to another. ...
    (microsoft.public.exchange2000.information.store)
  • Re: MS Access Security Local Database
    ... What I understand is that I must set up a workgroup file. ... time I read these 'faq's' I am told to delete the Admin from the Admin ... the "receiving computer") - you should split your app into front and back ... affect ALL databases on that computer. ...
    (microsoft.public.access.security)