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” …
SQL Server error message 3159 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 …
Restore transaction log with standby in SQL Server 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 …
Restore transaction log with norecovery in SQL Server 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 …
Restore transaction log SQL Server 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] …
Restore database SQL Server command with replace 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 …
Restore transaction log point in time Read More