SQL Server error message 3159
One of my friends working on SQL Server 2000 to 2005 faced following issue. Msg 3159, Level 16, State 1, Line 1 The tail of the log for the database “databasename” …
Read MoreTag: Restore
Restore transaction log with standby in SQL Server
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 in SQL Server
Restore 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 MoreRestore transaction log SQL Server
Backup 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 MoreRestore database SQL Server command with replace
Restore database SQL Server command with replace option is used when we need overwrite an existing database from a backup. The T-SQL command for same is shown below. RESTORE DATABASE [AdventureWorks2014] …
Read MoreRestore transaction log point in time
This 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 More