Re: MSSQL$SBSMonitoring Database size (SBS2003)



Hello Williams,

Thanks for your posting!

If you are using SBS Premium and have SQL server installed:

1. Start SQL Enterprise Manager
2. Expand Microsoft SQL Servers -> SQL Server Group
3. If you did not find the "YourServerName\SBSMONITORING (Windows NT)"
instance is listed, please use the following steps to add it.
a. Right click on the SQL Server Group and select New SQL Server
Registration
b. On the available server, please DO NOT choose local server. You should
manually input SERVERNAME\INSTANCENAME, such as SERVERNAME\SBSMONITORING
c. Follow the wizard and finish settings.
4. Then, expand YourServerName\SBSMONITORING (Windows NT) -> Management ->
SQL Server Agent -> Jobs
5. There should be a job named with SBS_Database_Cleanup

Hope it helps!

Best regards,

Brandy Nee

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------
Reply-To: "Al Williams" <donotreplydirect@xxxxxxxxxxxxxxxx>
From: "Al Williams" <donotreplydirect@xxxxxxxxxxxxxxxx>
References: <1DD26571-4F02-44FE-8767-12D3C48CCA2F@xxxxxxxxxxxxx>
<IXvLTy8SGHA.4660@xxxxxxxxxxxxxxxxxxxxx>
Subject: Re: MSSQL$SBSMonitoring Database size (SBS2003)
Date: Tue, 21 Mar 2006 11:58:04 -0700
Lines: 161
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Original
Message-ID: <eWsrjlRTGHA.4792@xxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.windows.server.sbs
NNTP-Posting-Host: s142-179-167-5.ab.hsia.telus.net 142.179.167.5
Path: TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.windows.server.sbs:254696
X-Tomcat-NG: microsoft.public.windows.server.sbs

Sorry to barge in, but I don't see any "SBS_Database_Cleanup that is
scheduled to run at 3:00 AM everyday" on my SBS2003 Premium SP1 system.
Is
it a scheduled task or something else?

--
Allan Williams


.



Relevant Pages

  • RE: SQL Server Express on SBS2003 standard
    ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ... After you applied the SBS 2003 SP1 successfully, you can install the ... SQL Server Express on SBS. ...
    (microsoft.public.windows.server.sbs)
  • RE: sql server licensing
    ... 2003 Premium client to access SQL server. ... license allows either one user or one device to access SQL Server ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • RE: First update to linked server fails
    ... this should be SQL server related issue. ... that you post this question into the SQL server newsgroup. ... you may want to contact Microsoft CSS directly. ... I am accessing a linked server through a VPN connection. ...
    (microsoft.public.windows.server.sbs)
  • RE: ShapePoint database upgraded to SQL Server 2K - change sa password?
    ... when upgrading to the SQL Server 2K. ... please understand this issue appears to be related to SQL Server. ... In the SQL newsgroup ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • Re: adprep not working on W2k server
    ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ... OS that is on the disc you would use to install the 2003 Server? ...
    (microsoft.public.windows.server.sbs)