This can cause a performance issue, as this is a blocking operation. The transaction that that initiated the log growth
Continue readingAuthor:
Change recovery mode for databases in SQL Server
–Change the recovery mode for databases: USE master; GO — Set recovery model to SIMPLE ALTER DATABASE Test SET RECOVERY
Continue readingHow to find the recovery mode for each database ?
Through Below query we can find out the recovery model of SQL Server Databases:- select [name], DATABASEPROPERTYEX([name],’recovery’) As RecoveryMode from
Continue readingHow 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