Re: MSSQL$SBSMonitoring Database size (SBS2003)
- From: v-branee@xxxxxxxxxxxxxxxxxxxx ("Brandy Nee [MSFT]")
- Date: Wed, 22 Mar 2006 08:08:54 GMT
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><IXvLTy8SGHA.4660@xxxxxxxxxxxxxxxxxxxxx>
From: "Al Williams" <donotreplydirect@xxxxxxxxxxxxxxxx>
References: <1DD26571-4F02-44FE-8767-12D3C48CCA2F@xxxxxxxxxxxxx>
Subject: Re: MSSQL$SBSMonitoring Database size (SBS2003)Is
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.
it a scheduled task or something else?
--
Allan Williams
.
- References:
- RE: MSSQL$SBSMonitoring Database size (SBS2003)
- From: "Brandy Nee [MSFT]"
- Re: MSSQL$SBSMonitoring Database size (SBS2003)
- From: Al Williams
- RE: MSSQL$SBSMonitoring Database size (SBS2003)
- Prev by Date: Re: Weird problem with password authentication
- Next by Date: Re: Administrator rww stopped working
- Previous by thread: Re: MSSQL$SBSMonitoring Database size (SBS2003)
- Next by thread: SBS 2003 + Mac OS X
- Index(es):
Relevant Pages
|