I"m fairly new to SQL administration. Wanted to hear what some best practices are for backups. Currently we have a nightly maintenance plan that runs and does a full backup. Our databases run under simple recovery model.
While we can capture full's every night, we are not doing anything else like "re-index or re-build" indexes. Looking for some info on createing a nightly maintenance plan that will do the index reorganizing/rebuilding/shrinking all in one. What are the pros to doing the re-organizing and rebuilding nightly and what are the cons.
Also interestd in seeing what others do with their datbases to prevent them from growing and becoming fragmented.