Disabling SQL Meraj 05.07.2007 17:42:00 Hello, I am currently not using anything that works with SQL, would it be a problem if I disable SQL to free up some RAM? And if I do disable it, and do require it later, would it be quite difficult to start it back up?

Re: Disabling SQL "Johnfli" <john[ at ]ivhs.us> 05.07.2007 17:46:43 Open up teh SQL Server Service Manager Select SQL Server in the Services Dropdown box Click on STOP Uncheck the box that reads "Auto-start service when OS Starts" If you need SQL later, just undo the above steps "Meraj" <Meraj[ at ]discussions.microsoft.com> wrote in message news:DE4E7863-14FB-4601-94CC-A4B8E9700D3C[ at ]microsoft.com... [Quoted Text] > Hello, > > I am currently not using anything that works with SQL, would it be a > problem > if I disable SQL to free up some RAM? And if I do disable it, and do > require > it later, would it be quite difficult to start it back up? > >

Re: Disabling SQL "Cris Hanna [SBS-MVP]" <crisnospamhanna[ at ]computingnospampossibilities.net> 05.07.2007 17:51:21 you don't have any MSDE instances running either? but yes...try disabling 1 service at a time to make sure something else really isn't dependent on it. -- Cris Hanna [SBS-MVP] ------------------------------------------------- Microsoft MVPs Independent Experts (MVPs do not work for MS) Real World Answers --------------------------------------------------------- Please do not contact me directly regarding issues "Meraj" <Meraj[ at ]discussions.microsoft.com> wrote in message news:DE4E7863-14FB-4601-94CC-A4B8E9700D3C[ at ]microsoft.com... [Quoted Text] > Hello, > > I am currently not using anything that works with SQL, would it be a > problem > if I disable SQL to free up some RAM? And if I do disable it, and do > require > it later, would it be quite difficult to start it back up? > >

Re: Disabling SQL "Claus" <cjobes[ at ]nova-tech.org> 05.07.2007 17:52:01 You can just go into services and set the services to disable. If you want to use them later, all you have to do is to set them back to enable. But be careful as some of the separate instances are used for SBS functionality like monitoring, SharePoint, etc. -- Claus "Meraj" <Meraj[ at ]discussions.microsoft.com> wrote in message news:DE4E7863-14FB-4601-94CC-A4B8E9700D3C[ at ]microsoft.com... [Quoted Text] > Hello, > > I am currently not using anything that works with SQL, would it be a > problem > if I disable SQL to free up some RAM? And if I do disable it, and do > require > it later, would it be quite difficult to start it back up? > >

Re: Disabling SQL "Russ Grover \(SBITS.Biz\)" <support[ at ]REMOVETHIS.SBITS.Biz> 05.07.2007 17:53:17 If you are using SBS as it's "intended" you are useing SQL Monitoring etc. However it does tend to grab more than it's share of memory You can tweak the usage of memory with osql command lines Howeveer there is a GUI out now that can help you tweak the amount of memory each SLQ instance uses. ------------------------------ Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services. http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en ----------------------------- Russ -- Russell Grover SBITS.Biz Microsoft Certified Small Business Specialist. MCP, MCPS, MCNPS, (MCP-SBS) support [ at ] SBITS.Biz Remote SBS2003 Support http://www.SBITS.Biz "Meraj" <Meraj[ at ]discussions.microsoft.com> wrote in message news:DE4E7863-14FB-4601-94CC-A4B8E9700D3C[ at ]microsoft.com... [Quoted Text] > Hello, > > I am currently not using anything that works with SQL, would it be a > problem > if I disable SQL to free up some RAM? And if I do disable it, and do > require > it later, would it be quite difficult to start it back up? > >

Re: Disabling SQL Meraj 05.07.2007 21:36:02 Thank you all for your input, and ideas. I will try disabling one service at a time... Thanks AGAIN! -Meraj "Russ Grover (SBITS.Biz)" wrote: [Quoted Text] > If you are using SBS as it's "intended" you are useing SQL > Monitoring etc. > > However it does tend to grab more than it's share of memory > You can tweak the usage of memory with osql command lines > Howeveer there is a GUI out now that can help you tweak the amount of > memory each SLQ instance uses. > > ------------------------------ > Microsoft SQL Server Management Studio Express (SSMSE) is a free, > easy-to-use graphical management tool for managing SQL Server 2005 Express > Edition and SQL Server 2005 Express Edition with Advanced Services. > > http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en > > ----------------------------- > Russ > -- > > Russell Grover > SBITS.Biz > Microsoft Certified Small Business Specialist. > MCP, MCPS, MCNPS, (MCP-SBS) > support [ at ] SBITS.Biz > Remote SBS2003 Support > http://www.SBITS.Biz > > > "Meraj" <Meraj[ at ]discussions.microsoft.com> wrote in message > news:DE4E7863-14FB-4601-94CC-A4B8E9700D3C[ at ]microsoft.com... > > Hello, > > > > I am currently not using anything that works with SQL, would it be a > > problem > > if I disable SQL to free up some RAM? And if I do disable it, and do > > require > > it later, would it be quite difficult to start it back up? > > > > > > >

Re: Disabling SQL "bass_player [SBS-MVP]" <bass_player[ at ]mvps.org> 06.07.2007 10:29:12 Just to be sure, dont disable these services MSSQL$SHAREPOINT MSSQL$SBSMONITORING If you have WSUS MSSQL$WSUS For the other instances, check whether thre are applications accessing them. "Meraj" <Meraj[ at ]discussions.microsoft.com> wrote in message news:06548FD8-4926-49B0-980D-F83078E1284C[ at ]microsoft.com... [Quoted Text] > Thank you all for your input, and ideas. I will try disabling one service > at > a time... > > > Thanks AGAIN! > -Meraj > > "Russ Grover (SBITS.Biz)" wrote: > >> If you are using SBS as it's "intended" you are useing SQL >> Monitoring etc. >> >> However it does tend to grab more than it's share of memory >> You can tweak the usage of memory with osql command lines >> Howeveer there is a GUI out now that can help you tweak the amount of >> memory each SLQ instance uses. >> >> ------------------------------ >> Microsoft SQL Server Management Studio Express (SSMSE) is a free, >> easy-to-use graphical management tool for managing SQL Server 2005 >> Express >> Edition and SQL Server 2005 Express Edition with Advanced Services. >> >> http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en >> >> ----------------------------- >> Russ >> -- >> >> Russell Grover >> SBITS.Biz >> Microsoft Certified Small Business Specialist. >> MCP, MCPS, MCNPS, (MCP-SBS) >> support [ at ] SBITS.Biz >> Remote SBS2003 Support >> http://www.SBITS.Biz >> >> >> "Meraj" <Meraj[ at ]discussions.microsoft.com> wrote in message >> news:DE4E7863-14FB-4601-94CC-A4B8E9700D3C[ at ]microsoft.com... >> > Hello, >> > >> > I am currently not using anything that works with SQL, would it be a >> > problem >> > if I disable SQL to free up some RAM? And if I do disable it, and do >> > require >> > it later, would it be quite difficult to start it back up? >> > >> > >> >> >>

Re: Disabling SQL Meraj 09.07.2007 22:42:02 So in other words I should not disable the following: MSSQL$SHAREPOINT MSSQL$SBSMONITORING MSSQL$WSUS "bass_player [SBS-MVP]" wrote: [Quoted Text] > Just to be sure, dont disable these services > > MSSQL$SHAREPOINT > MSSQL$SBSMONITORING > > If you have WSUS > MSSQL$WSUS > > For the other instances, check whether thre are applications accessing them. > > "Meraj" <Meraj[ at ]discussions.microsoft.com> wrote in message > news:06548FD8-4926-49B0-980D-F83078E1284C[ at ]microsoft.com... > > Thank you all for your input, and ideas. I will try disabling one service > > at > > a time... > > > > > > Thanks AGAIN! > > -Meraj > > > > "Russ Grover (SBITS.Biz)" wrote: > > > >> If you are using SBS as it's "intended" you are useing SQL > >> Monitoring etc. > >> > >> However it does tend to grab more than it's share of memory > >> You can tweak the usage of memory with osql command lines > >> Howeveer there is a GUI out now that can help you tweak the amount of > >> memory each SLQ instance uses. > >> > >> ------------------------------ > >> Microsoft SQL Server Management Studio Express (SSMSE) is a free, > >> easy-to-use graphical management tool for managing SQL Server 2005 > >> Express > >> Edition and SQL Server 2005 Express Edition with Advanced Services. > >> > >> http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en > >> > >> ----------------------------- > >> Russ > >> -- > >> > >> Russell Grover > >> SBITS.Biz > >> Microsoft Certified Small Business Specialist. > >> MCP, MCPS, MCNPS, (MCP-SBS) > >> support [ at ] SBITS.Biz > >> Remote SBS2003 Support > >> http://www.SBITS.Biz > >> > >> > >> "Meraj" <Meraj[ at ]discussions.microsoft.com> wrote in message > >> news:DE4E7863-14FB-4601-94CC-A4B8E9700D3C[ at ]microsoft.com... > >> > Hello, > >> > > >> > I am currently not using anything that works with SQL, would it be a > >> > problem > >> > if I disable SQL to free up some RAM? And if I do disable it, and do > >> > require > >> > it later, would it be quite difficult to start it back up? > >> > > >> > > >> > >> > >> > > >

Re: Disabling SQL "Henry Craven {SBS-MVP}" <sme[ at ]nevernever.lan> 09.07.2007 23:12:28 MSSQL$WSUS probably isn't that important ( your choice ) Keep the other 2 as they are SBS Integrated -- Henry Craven {SBS-MVP} "Meraj" <Meraj[ at ]discussions.microsoft.com> wrote in message news:FE524382-656C-4A59-914C-CDC868F7BB97[ at ]microsoft.com... [Quoted Text] > So in other words I should not disable the following: > > MSSQL$SHAREPOINT > MSSQL$SBSMONITORING > MSSQL$WSUS