Re: Sharepoint web site gone but database still intact

From: Antoine Victor (Victor_at_discussions.microsoft.com)
Date: 11/23/04


Date: Tue, 23 Nov 2004 12:29:02 -0800

I am having a similar problem...

My server crashed (power outage corrupted files)

I reloaded windows 2003 and WSS

I still have the config database and the content database in MSDE but the
IIS content is gone.

I have tried to rebuild the site and then replace the database but have had
no luck, perhaps I am missing something.

Any help would be appriciated as we have no backup... another case of
functional prototype goes into production... :(

"Wayne Atkinson" wrote:

> if you learn any tricks, please post.
> I am off on a much earned holiday for a week but when I return I am going to
> document the process better by breaking a setup on a test box.
> Good luck with the restore.
> Wayne
> "JD" <JD@discussions.microsoft.com> wrote in message
> news:0D36FC8A-0E16-4190-8189-4A0B5A786267@microsoft.com...
> >I decided to open a support call to Microsoft and they are working with me.
> > Seems as if part of the DB may be corrupt. We were successful in getting a
> > portion of the sites back, but as luck would have it, the site that is
> > important is unrecoverable at this point. We are recalling tape media and
> > will proceed down that road. Thanks for your help.
> >
> > "Wayne Atkinson" wrote:
> >
> >> Yes, I have.
> >> At what stage did you fail?
> >>
> >> "JD" <JD@discussions.microsoft.com> wrote in message
> >> news:23C44F03-71C8-4A1A-A575-2C393077BAF9@microsoft.com...
> >> > Hi Wayne,
> >> >
> >> > Thanks for the post. I followed your suggestions and can't seem to
> >> > bring
> >> > this back to life. If I may ask, have you successfully done this in the
> >> > past
> >> > or is this a "it should work" philosophy. Everything I read suggests
> >> > that
> >> > without a backup of the front end, having the back end does you no
> >> > good. I
> >> > find that hard to believe and am hoping that you've been successful in
> >> > this
> >> > procedure. Thanks.
> >> >
> >> > "Wayne Atkinson" wrote:
> >> >
> >> >> Note: before you attempt this, backup the configuration db and all
> >> >> the
> >> >> content databases just to be safe!
> >> >>
> >> >> I am assuming you have an SQL server that you have access to and can
> >> >> use
> >> >> Enterprise Manager to view the data.
> >> >>
> >> >> To find out which database is for which site query the Sites table
> >> >> for
> >> >> each
> >> >> of the content databases. You should see something like
> >> >> STS_Servername_12345566 for each content db. Open SQL Query Analyzer
> >> >> select
> >> >> one of the databases and run "Select * from Sites" Make note of the
> >> >> URL
> >> >> and
> >> >> the db name.
> >> >>
> >> >> Once you have installed WSS you can recreate the virtual directories
> >> >> and
> >> >> use
> >> >> the same host headers for each
> >> >> Create a new Configuration database.
> >> >> Extend each site and create a new database but use a new app pool (
> >> >> make
> >> >> sure the app pool account has Security Admin and Create database
> >> >> rights
> >> >> on
> >> >> the SQL server)
> >> >> once it is created remove the new content database and connect to the
> >> >> old
> >> >> one ( see above)
> >> >> You should be able to see the sites again...
> >> >>
> >> >> This explanation is a bit simplistic, but you should be able to get
> >> >> them
> >> >> back.
> >> >>
> >> >> good luck
> >> >>
> >> >>
> >> >>
> >> >> "Craig" <poze9@hotmail.com> wrote in message
> >> >> news:a64c0166.0410070724.147eceeb@posting.google.com...
> >> >> > We had a little issue and one of our IT folks removed IIS on our
> >> >> > sharepoint server, of course blowing away any sites or virtual
> >> >> > directories. Is there any way to recover or re-create this ? Does
> >> >> > anyone have any suggestions on the steps it would take to re-create
> >> >> > and attach to the existing database ?
> >> >> >
> >> >> > Any help would be great.
> >> >> >
> >> >> > Thanks,
> >> >> > -Craig
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>



Relevant Pages

  • RE: How to enter data into a table using a combobox
    ... I am having some issues with the NotInList function. ... > you don't need to mess with the database name. ... >> more luck. ...
    (microsoft.public.access.forms)
  • Re: search component using picture alternative text
    ... Its doesn't take luck. ... Here's a tidbit...put HTML comments into the fields of your database ... preventing their display. ...
    (microsoft.public.frontpage.programming)
  • RE: Menubar Gone -- How to Recover It?
    ... LarryP -- I'll be watching posts to this problem with interest. ... and even created a new blank database and did likewise. ... in the registry somewhere or in her user profile that says when SHE launches ... Rightclick-Customize-Menubar-Reset, no luck. ...
    (microsoft.public.access.setupconfig)
  • Re: need a reply of this question
    ... You will have more luck getting your questions answered in the future if you ... make the subject of the post relevant to the question you have. ... the problem is in the code when i want to insert the selected data to a ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SharePoint Server woes - Please help!
    ... I am using Windows SharePoint Server, ... > Server and Configuration Database are set up to the correct DBs. ... >>> Config database. ...
    (microsoft.public.sharepoint.portalserver)