RE: SBS SQL Srv - Simple or Full log mode for DB files?
- From: v-bpeng@xxxxxxxxxxxxxxxxxxxx ("Bill Peng [MSFT]")
- Date: Fri, 24 Aug 2007 03:27:50 GMT
Hi Henrik,
Thank you for posting here again.
Actually, the sbsmonitoring database issue is a known issue. However, we do
not recommend you to modify the database itself. As a quick solution, you
can simply re-configure Monitoring and Reporting in Server Management.
To do so:
1. Open Server Management.
2. Click Monitoring and Reporting.
3. Click Set Up Monitoring Reports and Alerts.
4. Click Next.
5. Choose "Reinstall monitoring features" and click Next.
6. The system will prompts "This option will reinstall the monitoring
features that you will select in the following pages of the wizard. If you
choose to continue, your previous monitoring configuration will be
overwritten and all existing monitoring data will be deleted".
7. Click Yes, and follow the instruction to finish the wizard.
By doing so, the monitoring database will be purged and reconfigured.
Hope this helps.
Sincerely,
Bill Peng
MCSE 2000, MCDBA, CCNP, CCDA
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
=====================================================
The public newsgroup only focuses on SBS related technical issues, for
other Microsoft products, we recommend you to post to appropriate newsgroup
to get most qualified responses.
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 notification. 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 PSS 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.
--------------------
From: "Henrik" <henrik@xxxxxxxxxxx>83.227.148.196
Subject: SBS SQL Srv - Simple or Full log mode for DB files?
Date: Thu, 23 Aug 2007 18:15:58 +0200
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.2929
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2929
Message-ID: <eyTIlDa5HHA.600@xxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.windows.server.sbs
NNTP-Posting-Host: ua-83-227-148-196.cust.bredbandsbolaget.se
Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:58496
X-Tomcat-NG: microsoft.public.windows.server.sbs
Hi ,
What Is recomended to use, simple or full logging mode In SQL for example
sbs monitoruing DB?
My log file for SBS Monitoring was set to Full and with auto growth and
ended up with 65Gb of size before a shrink was done.
Pls, some advice Is appreciated.
Regards
Henrik
.
- References:
- SBS SQL Srv - Simple or Full log mode for DB files?
- From: Henrik
- SBS SQL Srv - Simple or Full log mode for DB files?
- Prev by Date: Re: Client computers cannot acces internet
- Next by Date: Re: Automatic Updates on Server Turned on & greyed out - yikes!
- Previous by thread: Re: SBS SQL Srv - Simple or Full log mode for DB files?
- Next by thread: RE: 3 Sites in a SBS Domain
- Index(es):
Relevant Pages
|
