Skip to content

Sunday, May 11, 2025

Latest:

Changing Service tiers? Do you need downtime?
Different Database Services in AWS
Google Launched second Cloud Region in India
SQL Server IaaS Agent Extension |Part-1
Day-3 | SQL Server Internals and SQL Azure Workshop | IBM Noida

SQLChamp

Let's learn together!

Home
LearnSQL
SQLServer
SQLTips
Azure Data Platform
- SQLAzure
- SQLServer on Azure VM
Best Practices
Speaking Events
- In-Person Events
- Events
Contact – us
- form7

sys.database_recovery_status

March 30, 2016 Sarabpreet Singh Anand

Auto-Truncate Log in Full Recovery Model

FULL Recovery model: This means that all database changes are fully logged and ideally the log records should stay in

Archives

Azure (2)
Azure Data Platform (32)
Azure Data Platform (2)
Best Practices (37)
Events (9)
In-Person (9)
In-Person Events (22)
Latest Announcements (6)
LearnSQL (32)
Powershell for SQL (5)
Powershell-Basics (1)
Pro-Tip (1)
Product Reviews (1)
Speaking Events (18)
SQL for Beginners (5)
SQL Server (1)
SQLAzure (33)
SQLServer (15)
SQLServer on Azure VM (17)
SQLServer on Azure VM (1)
SQLTips (22)
Uncategorized (9)
Webcast (6)

Always Encrypted (6) azure (32) azure portal (6) Azure SQL Database (10) backup (5) backup encryption (6) cloud (6) Database (4) DDM (5) deadlock (4) Dynamic Data Masking (5) error log (3) event (21) Execute As (4) Execution context (3) free (10) Free event (8) free sql learning (6) Function (3) grant (3) gurgaon (9) in person (9) learn (3) Learning (9) limitations (4) MCT (8) Microsoft (8) MVP (8) permissions (3) powershell (8) Powershell4SQL (3) restore (3) sarab (19) sarabpreet singh anand (4) security (11) SQL (51) SQL 2012 (5) SQL 2014 (8) SQL Azure (12) SQLAzure (10) SQL Database (10) SQL Saturday (9) SQLServer (31) sql server (17) sql server 2012 (6) SQLServer 2014 (9) sql server 2014 (4) SQL Server 2016 (8) SQLServerday (13) SQL Server day (9) SQLServer Workshop (3) sql tips (4) step-by-step (4) t-sql (8) tech days (3) tips (4) Training (10) tricks (3) webcast (7) windows azure (6)

Copyright © 2025 SQLChamp. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.