database

Hi All, I am very new to SCCM can you please help me understand how SCCM removes old data from the SQL DB. 1. How long is the data retained in SQL database. For example if we disable deletion of any old data from the site maintenance tab how long is the data retained on the SQL server...

Dear all, I want to know the best way to handle SCCM database. As my SCCM Database size is approx 50GB now and i am thinking to create a new database and attach it with an existing one so that the previous one size stop growing more. Please let me know if it is possible and how in steps...

Hi everyone. I have a problem that is driving me crazy !!! I describe my scenario : SCCM SERVER: WINDOWS SERVER 2012 R2 STANDARD; SCCM 2012 SP2 SQL SERVER (EXTERNAL): WINDOWS SERVER 2012 R2 STANDARD; SQL 2012 SP3 CU7 When I start the installation I get the following error:

I have installed SCCM and have the reporting role enabled. I can run reports from within SCCM but I am constantly being prompted for username and passwords when I try to access the reports from the reports manager URL. when I log into the web URL with my username and password, I am not able to...

Hi Prajwal, I need assistance in database grow very rapidly in SCCM after upgrade to SCCM 2012 R2 SP1 to SCCM 1710, as checked the report server database grow very huge around 100 Gb, database recovery model is Full, Kindly suggest what would be the issue

Hai Prajwal, I have followed your SCCM installation procedure,but during SQL installation in server accounts you have done a local account with domain administrators permissions, but I have given directly domain account itself.As i don't know how to create a new one and append domain...

Hello, As of recent all of my Task Sequences are not being seen from any of my computers-- which is a totally different issue. I believe that doing the upgrade to 1706 from 1702 may fix this. I've attempted to do the upgrade but have been running into issues. I've combed the cmupdate log and it...

SQL is getting full is there a tool or any other way to restrict how much drive space SQL will not suck up all available drive space?

I have a weird situation and am completely stumped as to a resolution. To start with, my organization had their root CA cert expire on Monday and we had to recover from that over the week. It appears we are back in order, a new CA was stood up and all is well, all existing certs have been...

Hi, I need suggestion for Database, My company is going to implement a new ERP System, we have a existing database for use of a big Application , would you please suggest me which is the best way to use a Database, should i use existing database or make new SQL Server for new Database Thanks...

Ok so this is a biggy. We have a client who has contacted us that their SCCM box (Virtual Hyper-V 2012 r2) will not boot. It is reporting inaccessable boot device. We have tried various things to get this back up and running, reparing all of the EFI boot file etc, but its refusing to start...