SQL Server: SQL Server is a database management system that includes several data management and analysis technologies. It includes better compression features, which also helps in improving scalability and enhancing the indexing algorithms and introduce the notion of filtered indexes.It also provides support for structured and semi-structured data. It includes capabilities for transparent encryption of data (TDE) as well as compression of backups through Recovery Models. Database ArchitectureNote: Right Click on Database >> Go to Properties >> Go to Option. On the Right side you can find recovery model.Note: This is a very easy method and it gives all the database information in one script.RECOVERY MODELS: Many of us have worked on systems where every minute of activity is important and needs to be backed up as soon as possible. Systems require different backup strategies, depending on the criticality of the information stored in them and before beginning to back up a SQL Server database, you need to know which recovery model the database is using, as by default, SQL Server databases are set to Full Recovery mode, which means they maintain sufficient logs to restore to any specific point in time. From SQL Server 2000 onwards microsoft supports three different recovery models: SIMPLE Recovery Model, FULL Recovery Model and BULK_LOGGED Recovery Model.The following table summarizes the recovery models and backup types available with each recovery model.SIMPLE Recovery Model: The Simple Recovery Model as its name says is very "simple". In this model the SQL server maintains only a minimal amount of information in the transaction log. The databases using the Simple Recovery Model may restore full or differential backups only. When a database is set to Simple Recovery, it means log files are not kept permanently, so when a TSQL statement executes, changes are written to the data and log files, but they are not kept in the log file for long before being truncated. Ideally Simple Database Recovery Model is best suited for user databases which are in Development or Test environment, where there is a reduced need for frequent database backups. This recovery model is also suited for databases which mostly contain read only data or on those databases where changes happen infrequently.T_SQL Sets to Simple Database Recovery Model:ALTER DATABASE SemiProject SET RECOVERY SIMPLEGOFULL Recovery Model:The Full Recovery Model provides everything, as this allows the fullest set of backup options which in turn gives you the fullest set of recovery options. Every SQL Server database has a Transaction Log and every Insert, Update and Delete transaction that occurs is placed in the transaction log. Changing the Recovery Model to FULL tells SQL Server to keep all committed transactions in the Transaction Log until there is a backup. Once a backup has occurred, SQL Server will remove all committed transactions that have been added to the database from the log.Benefits of FULL Recovery Model:
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: