
Create an automated database and tranasction log SQL backup job, in the description indicate why the backup method was chosen, the frequency and the location. Test the SQL job by creating a backup of database, then restore it from backup. Script out a table with data and a stored procedure and create them within another database.