replace Archives - SQLServerGeeks

SQL Server / SQL Server Accidental DBA Series

SQL Server error message 3159

April 12, 2015December 20, 2019 - by SQL Geek - Leave a Comment

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 / SQL Server Accidental DBA Series

Restore database SQL Server command with replace

August 2, 2014December 23, 2019 - by SQL Geek - Leave a Comment

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] …