SQL Server Education (by the geeks, for the geeks)
Restore transaction log with standby option leaves the database read only mode. The uncommitted transaction are undone and saved in a file so that recover effects can be reversed when database …
Read MoreRestore transaction log with NORECOVERY option is used when restoring multiple transaction log. Consider a backup strategy where in full backup is being taken once a week and transaction log backup …
Read MoreBackup and Restore are the common tasks that a DBA needs to perform almost daily. In this blog I’ll talk about how to restore a transaction log in SQL Server. A …
Read MoreThis is an awesome feature where in one can restore transaction log point in time. A database can be restored to a specified using STOPAT option in restore command. Let’s look …
Read MoreEvery now and then questions come up forums asking about how to truncate log file in SQL Server. Truncating a transaction log file means clearing out space in the log file. …
Read More