Windows Server - Move SBSMonitoring DB on SBS 2008 Std
Asked By Dani Avni
23-Jan-10 01:41 AM
i want to move the SBSMonitoring DB files (mdf,ldf) from one disk to another.
i know technicly how to do it but am not sure if that is supported.
Database
(1)
WizardsIf
(1)
Grover
(1)
Netshop.virtual
(1)
Wizards
(1)
SBS2008
(1)
Ldf
(1)
SBS
(1)
Russ SBITS.Biz [SBS-MVP] replied to Dani Avni
You can move just about every database with wizards
If I may, ask?
Why you need to move this database?
SBS2008 can change Volume Sizes so if you are running out of space you can
re arrange drive sizes.
Russ
--
Russell Grover - SBITS.Biz [SBS-MVP]
Microsoft Gold Certified Partner
Microsoft Certified Small Business Specialist
24hr SBS Remote Support - http://www.SBITS.Biz
Microsoft Online Services - http://www.microsoft-online-services.com
Steve Foster replied to Dani Avni
Yes, it is.
--
Steve Foster
------------
Please reply only to the newsgroups.
For SSL Certificates, Domains, etc, visit.: https://netshop.virtual-isp.net

and have them do it. Be it Microsoft or your SBS Specialist guy. Russ - - Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist SBS2003 SBS2008 it just recent Restore your OS Drive from backup That's the easiest Russ - - Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist SBS2003 SBS2008 the issue more easily than the state you are in now. 2) Try the SBS wizards. In particular the FNCW and CTIW could be useful. I doubt the IAMW wizard will do much in this instance, but it cannot hurt either. These wizards are interlaced, so the "I doubt" is literal; they have surprised me by rebuilding stuff to get wrong. In general I am not a fan of black box computing. Running wizards without knowing what the wizard is doing is not very appealing, even if it leads workable solution. Indeed, what happens the next time something breaks, should one begin blindling running wizards one by one, with hope and a prayer? Besides, there is nothing being done in cannot easily be done using the tools given. So the advice to "try" the various wizards you list is not very helpful to me. Your item 3 is exactly what I same trap as I did. Regards, Rob Rob No offense, But actually not running the wizards are probably where it went wrong. Microsoft does not disable snap-ins because they are
SBS Monitoring 4GB (2008) Now what? Windows Server How do I either delete the monitoring database or move it? I have SQL Express, can see the database, have shrunk the log database, but stuck with the .mdf SBS Monitoring. Errors all over the place saying I can Discussions SQL Express (1) SQL Server (1) WMICollectedData (1) MICollectedData (1) SBSMonitor (1) ManglingSBS (1) Database (1) Diagnostics (1) I'd start here: http: / / blogs.technet.com / sbs / archive / 2009 / 07 gigs, it will take awhile. -Cliff Running it now. I had cleaned up the log database but it is growing now with this command running. Hope this does it, thanks. I do I stop it? The command ate up all my HD space and now my database is corrupt. Any ideas? Can I move it to another partition? Even better, is there thing and start all over? No, you run the risk of major mangling SBS Monitoring Database issue collection. = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = As you may already know that monitoring on SBS 2008 uses SQL express edition instance. In SQL express edition, there is a limitation of a database size which is 4GB. So what is going to happen if monitoring database is full
no longer access company web. In the Application log these messages are being generated; The database ShareWebDb on SERVER \ Microsoft##SSEE is not accessible to missing Windows Internal Database signatures. We do not use company web but i would like to get it up SQL Server (1) Error (1) Have you Restarted the Service Since the update? Russ - - Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Small Business Server / Computer Support - www.SBITS be that you no longer have the appropriate permissions to t he server farm, the database server hosting the server farm is unresponsive, the configuration database is inaccessible or this server has been removed from the server farm. To diagnose this file - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - Unknown SQL Exception 5070 occured. Additional error information from SQL Server is included below. Database state cannot be changed while other users are using the database 'SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6' ALTER DATABASE statement failed. sp_dboption command failed. - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Failed to initialize SharePoint Products and Technologies upgrade. An exception
are "Free" applications you need deployed like Java etc. try http: / / ninite.com / Russ - - Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist 24hr SBS Major effort expense. If you do find out. . Please let me know Thanks Russ - - Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist 24hr SBS all Clients QuickBooks is close but still a PAIN in the @#$# to administrate Russ - - Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist 24hr SBS Steve Foster - -- -- -- -- -- - Please reply only to the newsgroups. For SSL Certificates, Domains, etc, visit.: https: / / netshop.virtual-isp.net Thanks Steve but I think you misunderstood. These are not volume licenses that a good ROI) :( If it is for 10 or so that sounds great :) Russ - - Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist 24hr SBS They do not realize the million of tiny fish all wanting to bite. . . Russ - - Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist 24hr SBS you getting Server Managed Software? it is much easier to deploy and manage? RUss - - Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist SBS2003 SBS2008
Server (1) Linux (1) NNTP service (1) Bit (1) Microsoft Online Services (1) Russ Russell Grover (1) Joe Brian Cryer (1) A quick Google turns up no obvious candidates, other than run your own NNTP Server for? - - Steve Foster For SSL Certificates, Domains, etc, visit.: https: / / netshop.virtual-isp.net Hi Joe. Thank you for the recommendation. I do not want to learn looking at the Message Pixels offering. - - Steve Foster For SSL Certificates, Domains, etc, visit.: https: / / netshop.virtual-isp.net Brian there is a NNTP Service in SBS2003 (if my memory serves me non Profit group Let me Know and I will host for you for free. Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Remote Small Business Server / Computer Support - www looking at the Message Pixels offering. - - Steve Foster For SSL Certificates, Domains, etc, visit.: https: / / netshop.virtual-isp.net russ@REMOVETHIS.sbits.biz says. . . The claim that NNTP is dying has been