Through Below query we can find out the recovery model of SQL Server Databases:- select [name], DATABASEPROPERTYEX([name],’recovery’) As RecoveryMode from
Continue readingCategory: SQL Server -DBA
SQL Server -DBA, SQL Server Services, who dropped or altered tables,procedures or databases in SQL Server, What in SQL Server
How to view the space used and allocated by transaction log?
DBCC SQLPERF (LOGSPACE);
Continue readingSQL Server Recovery models and their roles
There are 3 recovery models in SQL Server :- Simple Full Bulk-Logged Simple recovery model Transaction log backups
Continue readingWhat is the reason behind of transaction log file reach out of control in size ?
Transaction log backups are not occurring while in Simple recovery mode Very long transactions are occurring, like indexes of
Continue readingWhat is transaction log file and its purpose?
The primary function of the transaction log file is to: Record all changes to the database Record changes
Continue readingSQL Server System Databases
Each time you install any SQL Server Edition on a server; there are four primary system databases, each of which
Continue readingHow to identify your Microsoft SQL Server version?
We can find out the SQL Server version details from below query:- select @@version
Continue reading