If I change from Weekly scanning to Daily scanning, do I need to increase the size of the drive that the database is on?
If you keep the same retention settings then yes, daily scanning will increase the size of the database pretty quickly depending on what exactly your scoped to scanning daily