A consultant changed the recovery model from full to simple for our production SQL databases. I would like to set the recovery model back to full. However, the log files (.ldf) have a date/time which is the same as the .mdf files. I'm not sure what to do with the log files. Should I delete them or leave them alone? I wonder why the log files have the same date/time as the the .mdf files if the recovery model is set to simple? Thank you.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.