Re: sharepoint crashed, along with most of the server

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

I did run it Les, found a few issues, Recieve side scaling, task offloading,
tcp chimney, etc, which i fixed. Also noted a line that states
'MSSQL$Sharepoint instance is not using SQL 2000 SP 4' not sure yet how to
fix this issue, unless it is to simply reapply Sql 2000 sp4.

Also found KB326672 that should resolve my exchange routing engine issue.

"Les Connor [SBS MVP]" wrote:

Go with the SBS Best Practices Analyser right now, it may not resolve all
the issues but is a great place to start. The link is in my SIG below.

--
Les Connor [SBS MVP]
________________________
Get the SBS BPA here:
http://support.microsoft.com/kb/940439/en-us


"CGTech" <CGTech@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AD56D0B0-1593-4639-A2E0-6469FF3E477C@xxxxxxxxxxxxxxxx
Lovely situation for the first day back at work after an 8 month stress
leave.. ;-)

Situation:

Server is an SBS2003R2, fully patched premium version.

Customer attempted (I think) to disable the Internet Explorer Enhanced
Security on the server - but I think he somehow ran a security template
instead. Situation once on site was as follows;

the following services were completely gone:

DNS
DHCP
Certificate Services
IIS

Companyweb and Sharepoint and Exchange of course were non functional.

Next step was to ascertain the status (PLEASE GOD!!!!!) of the
backups.......

There weren't any.......

(please note above that i have just returned from stress leave, and this
is
now the second day back....groan)

Fast forward to today......complete Intranet portion of SBS2003 has been
reinstalled , DNS, DHCP, Cert Services up and running, Exchange running
with
exception of Routing Engine having an issue, Win2003 sp2 installed ,
Ex2003
sp2 installed, company web and sharepoint seem to be working again but are
clean installs.

Now, the following questions;

1/ How do you determine whether or now Sharepoint was using Sql 2000 over
MSDE in a database? (i'm assumeing it was sql, but not 100% sure)

2/ How do you reattach (or can you) an existing sharepoint database to a
new
or blank sharepoint install? (the database is on a seperate drive, size
about
21GB) There is not enough free space on drive c: to attempt moving the
database to the \\mssql\sharepoint\data folder, or import...



.

Relevant Pages

  • RE: transfer companyweb config db
    ... configuration database for sharepoint services to a new location on the sql ... You may mistake SQL server conception. ... Move the Monitoring Database ... >project web access not working correctly is to use a config database on ...
    (microsoft.public.windows.server.sbs)
  • Re: WSS MSDE DB Location Change Nightmare
    ... STS_servername_1 database. ... able to do your reinstall of MSDE and restore over top of the new Content DB ... Sharepoint Services was installed. ... Pool Is the Account That Has the Required Permissions to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Sharepoint has two datasets
    ... Please feel free to use this newsgroup. ... Microsoft CSS Online Newsgroup Support ... | Thread-Topic: Sharepoint has two datasets ... |> For your concerns about sharepoint database, ...
    (microsoft.public.windows.server.sbs)
  • I broke Sharepoint :(
    ... SBS was installed and the server was up and running including the default ... After 2 days I was looking at SQL backups I relaised that Sharepoint ... database and the other instances were not migrated accross. ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint - where are the files?
    ... use Sharepoint here, but access a few different Sharepoint sites of partner ... You can use the Lists without http urls. ... I understand about the database part, ... Opens it via SharePoint, makes some ...
    (microsoft.public.windows.server.sbs)