i have two databases:
this one was set up by a third party and they do not allow us to change the database to full recovery. so it is my understanding that if a database is in simple mode, then the only option for backup is the FULL BACKUP? we need to be able to recover it in 15 min increments. would this be possible without doing a full backup every 15min?
the other database we have full control over and we would like to be able to recover in 15min intervals. how do i set this up in sql server 2008? should we be doing transactional or differential or both?
how do i change a DB from simple to full recovery mode?