Sharepoint Services SSEE data folder contents

Hello,

Does anyone have a good resource or can tell me what the different
database files in the SYSMSI\SSEE\MSSQL.2005\MSSQL\Data folder
represent? I installed WSS 3.0 with default settings and am trying to
determine what is the standard environment vs how much is my content.
When I run catastrophic backups the backup size is only about 100
MB,while the WSS_content databases are much larger, so I'm looking for
some clarity. Any information would be helpful.

Thanks.

Steve

SamS
Wed Mar 05 17:46:48 CST 2008

just briefly you have installed SQL 2005 Express which has limitations of 6
GB I thinks (need to check).
In regards to WSS3.0 the content db is basically the DB for all your content
in your team sites, etc.such as total documents, etc. The config DB is
related to the WSS3.0 site\farm and how its configured. It has information
on your SharePoint environment so unless you add new team sites, databases,
servers, etc this file size will not change and if it does, it will be
small. You should only be concerned with the Content db and its size + the
associated log files.

SamS
<sslomovicz@gmail.com> wrote in message
news:e96ddd08-acf1-4d92-b0e9-7daf64778eac@i29g2000prf.googlegroups.com...
> Hello,
>
> Does anyone have a good resource or can tell me what the different
> database files in the SYSMSI\SSEE\MSSQL.2005\MSSQL\Data folder
> represent? I installed WSS 3.0 with default settings and am trying to
> determine what is the standard environment vs how much is my content.
> When I run catastrophic backups the backup size is only about 100
> MB,while the WSS_content databases are much larger, so I'm looking for
> some clarity. Any information would be helpful.
>
> Thanks.
>
> Steve

Mike
Wed Mar 05 23:07:18 CST 2008

> just briefly you have installed SQL 2005 Express which has limitations
> of 6 GB I thinks (need to check).

No. The limit is 4GB and it only applies to the version of SQL Server
2005 Express used by MOSS 2007 (and the independent installation of SQL
Server 2005 Express).

It doesn't apply to the version used by a WSS 3.0 Basic installation
which has no database size limits (and which is btw officially called
the "Windows Internal Database" although it too is indeed an embedded
version of SQL Server 2005 Express - just one without that db limit.

Mike Walsh
WSS FAQ http://www.wssfaq.com / wss.collutions.com
I regret that private e-mail questions will not be answered


SamS wrote:
> just briefly you have installed SQL 2005 Express which has limitations
> of 6 GB I thinks (need to check).
> In regards to WSS3.0 the content db is basically the DB for all your
> content in your team sites, etc.such as total documents, etc. The config
> DB is related to the WSS3.0 site\farm and how its configured. It has
> information on your SharePoint environment so unless you add new team
> sites, databases, servers, etc this file size will not change and if it
> does, it will be small. You should only be concerned with the Content db
> and its size + the associated log files.
>
> SamS
> <sslomovicz@gmail.com> wrote in message
> news:e96ddd08-acf1-4d92-b0e9-7daf64778eac@i29g2000prf.googlegroups.com...
>> Hello,
>>
>> Does anyone have a good resource or can tell me what the different
>> database files in the SYSMSI\SSEE\MSSQL.2005\MSSQL\Data folder
>> represent? I installed WSS 3.0 with default settings and am trying to
>> determine what is the standard environment vs how much is my content.
>> When I run catastrophic backups the backup size is only about 100
>> MB,while the WSS_content databases are much larger, so I'm looking for
>> some clarity. Any information would be helpful.
>>
>> Thanks.
>>
>> Steve
>

Ian
Thu Mar 06 02:41:52 CST 2008

On Thu, 6 Mar 2008 05:07:18 +0000, Mike Walsh wrote
(in article <#ggf#f0fIHA.5280@TK2MSFTNGP02.phx.gbl>):

> It doesn't apply to the version used by a WSS 3.0 Basic installation
> which has no database size limits (and which is btw officially called
> the "Windows Internal Database" although it too is indeed an embedded
> version of SQL Server 2005 Express - just one without that db limit.

That's very interesting info. Is it documented in the Microsoft documentation
anywhere? I'm just about to set-up a team site in work mainly for the wiki
and blog services. If there is no limit on the WID I'd be very tempted to use
it rather than install SQL 2005. It'll be a single server (VM hosted on
VMware ESX 3.5) with about 60 light users. I don't expect there to be lots of
documents stored in the DB.

Ian
--
Ian Robinson, Belfast, UK
<http://www.canicula.com/wp/>

Mike
Thu Mar 06 03:54:58 CST 2008

I can guarantee that it is correct information.

It's odd how often how people get this wrong. It was the same thing with
WSS 2.0 and yet both then and now even some book authors seem to be
convinced there is a limit.

In your situation I *would* install using WID providing the usual three
(or four)snags listed (don't ask me where!) don't bother you.

(only use for WSS dbs; on single server only; remote connections
problems of some kind and X)

Mike Walsh (WSS MVP)

Ian Robinson wrote:
> On Thu, 6 Mar 2008 05:07:18 +0000, Mike Walsh wrote
> (in article <#ggf#f0fIHA.5280@TK2MSFTNGP02.phx.gbl>):
>
>> It doesn't apply to the version used by a WSS 3.0 Basic installation
>> which has no database size limits (and which is btw officially called
>> the "Windows Internal Database" although it too is indeed an embedded
>> version of SQL Server 2005 Express - just one without that db limit.
>
> That's very interesting info. Is it documented in the Microsoft documentation
> anywhere? I'm just about to set-up a team site in work mainly for the wiki
> and blog services. If there is no limit on the WID I'd be very tempted to use
> it rather than install SQL 2005. It'll be a single server (VM hosted on
> VMware ESX 3.5) with about 60 light users. I don't expect there to be lots of
> documents stored in the DB.
>
> Ian

Ian
Thu Mar 06 07:47:01 CST 2008

"Mike Walsh" wrote:

> I can guarantee that it is correct information.

Excellent. I wasn't doubting you BTW. I just think I'll need to convince
others...

>
> It's odd how often how people get this wrong. It was the same thing with
> WSS 2.0 and yet both then and now even some book authors seem to be
> convinced there is a limit.

I've just bought Callahan's Mastering WSS3 and on page 7 it implies that
the SSEE DB installed with the basic install has limits. I quote, "...the
databases fill up more quickly...". If there is no limit how do they fill up?

>
> In your situation I *would* install using WID providing the usual three
> (or four)snags listed (don't ask me where!) don't bother you.
>
> (only use for WSS dbs; on single server only; remote connections
> problems of some kind and X)

I'm inclined to go with WID myself. Does the lack of Remote Access to the
database just mean I'll have to do my database management on the W2K3 server
directly? Not a problem for me. Or does it mean I'll not be able to give
users access from outside my network via the Internet? I doubt it's the
latter but be good to have that confirmed.

Cheers,

Ian
--
Ian Robinson, Belfast, UK
<http://www.canicula.com/wp/>

johnnyho034
Thu Mar 06 13:42:51 CST 2008

On Mar 4, 5:46=A0am, sslomov...@gmail.com wrote:
> Hello,
>
> Does anyone have a good resource or can tell me what the different
> database files in the SYSMSI\SSEE\MSSQL.2005\MSSQL\Data folder
> represent? =A0I installed WSS 3.0 with default settings and am trying to
> determine what is the standard environment vs how much is my content.
> When I run catastrophic backups thebackupsize is only about 100
> MB,while the WSS_content databases are much larger, so I'm looking for
> some clarity. Any information would be helpful.
>
> Thanks.
>
> Steve

Steve,

If you're looking for an adequate way to backup your Sharepoint
environment take a look at our website.

www.avepoint.com

If you have any questions give me a call or drop me an email.

Thanks,
John Hohenadel
312-558-1694
john.hohenadel@avepoint.com

sslomovicz
Sat Mar 08 13:37:28 CST 2008

Thanks for all the insight. I will have to look for a smart way to
back this up and eventually move this off to a larger drive. I'd most
likely get the agent for Backup Exec.

The next question is why I have two or three wss_content databases
with different GUIDs on the name? Does it have anything to do with
installing the service pack?



On Mar 6, 2:42 pm, johnnyho...@yahoo.com wrote:
> On Mar 4, 5:46 am, sslomov...@gmail.com wrote:
>
> > Hello,
>
> > Does anyone have a good resource or can tell me what the different
> > database files in the SYSMSI\SSEE\MSSQL.2005\MSSQL\Data folder
> > represent? I installed WSS 3.0 with default settings and am trying to
> > determine what is the standard environment vs how much is my content.
> > When I run catastrophic backups thebackupsize is only about 100
> > MB,while the WSS_content databases are much larger, so I'm looking for
> > some clarity. Any information would be helpful.
>
> > Thanks.
>
> > Steve
>
> Steve,
>
> If you're looking for an adequate way to backup your Sharepoint
> environment take a look at our website.
>
> www.avepoint.com
>
> If you have any questions give me a call or drop me an email.
>
> Thanks,
> John Hohenadel
> 312-558-1694
> john.hohena...@avepoint.com