New application seems to have wrecked a number of Sql Databases

Question

Post reply

New application seems to have wrecked a number of Sql Databases

Viewing 4 posts - 46 through 48 (of 48 total)

You must be logged in to reply to this topic. Login to reply

4data SSC Enthusiast Points: 100 More actions · Answer 1

Think I may have found something else, that may, or may not have a bearing!.

In the IIS Manager, Under the server, application pools, DefaultAppPool, I've noticed the following:

There is an item with Description: 'root', and Path: '<companyweb>'.

There is also one with Description: 'ROOT', and path: '<Quarantine Digest>'.

The former, clearly being the sharepoint site I've been harping on about, and the latter being part of the Antivirus thing that seemed to stop the companyweb from working.

Are these case sensitive, or could this be causing a conflict?

Let me know your thoughts - please!

4Data

4data SSC Enthusiast Points: 100 More actions · Answer 2

Hi all:

Just thought I'd post this for info.

I've sorted the issue out.

I ended up going through the following document until the Sharepoint Services 2.0 Companyweb was completely removed....

http://support.microsoft.com/kb/829114

Then going through this one, similarly, until the Monitoring and reporting function was also completely removed....

http://support.microsoft.com/kb/555432/en-us

After this, a quick server reboot, and test of the backup.... and it's working.

These two use the MSDE and it seems that' I've had to remove that entirely to get it going.

Problem is, I'm going to have to reinstall them in a while, but not until the backup is triple tested!

So thanks to everyone who helped me out on this, especially Jason who put up with my luddite ways without complaining once!

Regards

4Data

GTR SSCrazy Eights Points: 8007 More actions · Answer 3

We are glad that you could recover everything, Culprit is Sharepoint, You have to be real careful sharepoint.

EnjoY!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

4data (3/12/2010)
Hi all:
Just thought I'd post this for info.
I've sorted the issue out.
I ended up going through the following document until the Sharepoint Services 2.0 Companyweb was completely removed....
http://support.microsoft.com/kb/829114
Then going through this one, similarly, until the Monitoring and reporting function was also completely removed....
http://support.microsoft.com/kb/555432/en-us
After this, a quick server reboot, and test of the backup.... and it's working.
These two use the MSDE and it seems that' I've had to remove that entirely to get it going.
Problem is, I'm going to have to reinstall them in a while, but not until the backup is triple tested!
So thanks to everyone who helped me out on this, especially Jason who put up with my luddite ways without complaining once!
Regards
4Data

You're welcome.

Thanks for posting back with your answer.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events