Sql-server – Restore Database Wizard not launching

From your reply to my question, then it does appear to be too much backup history. For a one off cleardown, something along these lines will do it:

USE msdb
GO
DECLARE @days DATETIME
SET @days = DATEADD(day,-30,current_timestamp)
EXEC sp_delete_backuphistory @days
GO

That example gets rid of everything over 30 days old, so you may need to change the -30 for a value appropriate for your needs. But remember that you'll then have to build up any restores for backups over 30 days old from hand (may or may not be a problem for you, but thought I'd better mention it).

Going forward you can schedule that to run via a scheduled job to keep you small.

You can kill the task on the SQL Server that is verifying the log files, then you will be able to click Next to get to the next screen in the Wizard.

Just use the query below to find the task running under smsql, and use the kill command to remove the SPID.

The wizard will show a popup error, but will still allow you to continue to the next screen.

Here is a query to help find the SPID to kill:

DECLARE @who2 TABLE( 
    [SPID] INT, 
    [Status] VARCHAR(200), 
    [Login] VARCHAR(200), 
    [HostName] VARCHAR(200), 
    [BlkBy] VARCHAR(20), 
    [DBName] VARCHAR(200), 
    [Command] VARCHAR(200), 
    [CPUTime] BIGINT, 
    [DiskIO] BIGINT, 
    [LastBatch] VARCHAR(20), 
    [ProgramName] VARCHAR(200), 
    [SPID2] INT, 
    [RequestID] INT 
) 

INSERT @who2 EXEC sp_who2

select SPID, [Login], HostName, DBName, Command, LastBatch, [@who2].ProgramName from @who2
where [LOGIN] like '%smsql%'