Home » SQL Server » How to Restart an Interrupted SQL Server Database Restore ?

How to Restart an Interrupted SQL Server Database Restore ?


I am trying to restore database on SQL cluster & failover happen. Once the SQL Server came up on the other node all the databases came up, except for the database which was in restoration prior to the failover.

Now, We have 2 options one is to restore database again or second to start restore by WITH RESTART.

RESTORE DATABASE…WITH RESTART command is a very useful command which is available in SQL Server 2005 and higher versions. A Database Administrator can use this command to finish restoring an interrupted database restore operation.

Database Lamp is in restoring mode after unexpected failover.

After executing the RESTORE DATABASE…WITH RESTART command to successfully complete the database restore operation.

Below you can see that after running the RESTORE DATABASE…WITH RESTART command the database was successfully

restored allowing user connectivity.

Advertisements

2 Comments

  1. I just wanna say that your blog is very great. If you post more stuff like these, I’ll follow your website to read more interesting stuff.

  2. Johnluchy says:

    Hey, very nice article. Thanks for great posting.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: