I am working on SSIS to extract data from multiple source and save them in DB.. However all the data are stored together in the DB tables with no ID about where each one of them come from.. I wonder if there is any solution that allow me to add like a special identity for each group of data from different sources??
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