question

Hemant avatar image
Hemant asked

Undo restore database SQL Server 2005

Hello, I accidentally restored a SQL Server 2005 database with a wrong backup. Is there any way to undo this operation and restore to previous state? It's urgent! Regards, Hemant
backup-restore
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Leo avatar image Leo commented ·
As Pavel siad, there is no way to go back to the original state. You need to apply the other backup (up to date backup).
0 Likes 0 ·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
You will have to restore it from correct backup.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Håkan Winther avatar image
Håkan Winther answered
Pavel is right, the only thing you can do is to restore the correct backup. You can't get back to previous state unless you have a recent full/differential backup and transaction log backups.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.