Microsoft Assessment and Planning Toolkit SQL limits and recommendations
When you are about to run MAP (Microsoft Assessment and Planning Toolkit) assessment it comes by default with a SQL Server 2008 R2 Express database. This has a limit of a database of 10GB. This is in many cases not a problem but in larger environments it can be.
My experience tells me that a 10GB database is good for keeping data for about up to 10 000 machines. If you hit the limit the best option is to use a fully licensed SQL Server which has no limits on the database size.
The second option is to divide the scans to say for instance different OUs and switch between multiple databases. This does not give a combined report in any way so it is definitely not the best option but it will get you there.
The latest version of MAP 6.5 can be downloaded from Microsoft Download Center.
Creating the perfect and fully automated reference image for Windows operating systems
USMT 4.0 update now migrates Office 2010 settings
HOWTO: Prevent deploying Windows over VPN
About Author
Andreas Stenhall
I'm Andreas Stenhall and my work passion is the Windows client in combination with Microsoft 365 security and management services. I do consulting, I produce and teach my own courses, I lecture and I present and my formal work title is prinicipal workplace advisor and architect at Coligo in Stockholm, Sweden. I'm also proud to be an Microsoft MVP since 2009. I have presented at BUILD, TechEd in the US and Europe and regional TechDays. Follow me on twitter @AndreasStenhall.