Database Restore | Varinder Sandhu

SQL Server – How to restore the mirroring database

Varinder Sandhu SQL, SQL-Advanced, Varinder Sandhu

Now here we have question regarding the Mirroring Database: How can we recover the data from mirror database? How to restore the mirroring database? Here I would like to clear that we cannot restore a database that is involved in Mirroring without removing Mirroring. Removing the Mirroring using T-SQL ALTER

» Read more

Database Restore, mirroring database, SQL Server

SQL Server 2008R2 – Database Restore – failed 38 (reached the end of the file)

Varinder Sandhu SQL, SQL-Backup & Restore, SQL-Tips and Tricks, Varinder Sandhu

While restoring the SQL database error occurred… Through UI following error occurred Through Script following error occurred Script: RESTORE DATABASE mydb FROM DISK = 'D:\ DB Backup\mydb.bak' WITH MOVE 'mydb_Data' TO 'E:\Database\mydb.mdf', MOVE 'mydb_Log' TO 'E:\Database\mydb.ldf', REPLACE GO Msg 3203, Level 16, State 1, Line 1 Read on “D:\ DB

» Read more

Database Restore, SQL Server

SQL Server – Validation of Backup

Varinder Sandhu SQL, SQL-Advanced, SQL-Backup & Restore, SQL-Tips and Tricks, Varinder Sandhu

Database backup are insurance policy for a database, we need to ensure that backups created are valid and useful. To validate the backup, we can use following command Restore verifyonly from <backup device> When a backups is validated, SQL Server performs the following steps Calculated a checksum for the backup