I need a trigger that will update a table with values inserted into another table.
Say an insert is done to table "A". This table has some data columns and a FK column to table "B". Upon insert, I want to update table "B" using the FK in a WHERE clause and setting 3 other data columns, all of which exist in both tables.
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