When restoring Enterprise MGR times out 1

[abuchan]

When I select restore from the Enterprise Manager the app Times out for a few minutes aprox 10mins. It the comes up and can be addressed and I can resotre the DB.
A DBCC INPUTBUFFER shows during this time it is continiously looking for this:
select physical_device_name,device_type from msdb..backupmediafamily where media_set_id = (select media_set_id from msdb..backupset where backup_set_id = 2596)
select physical_device_name,device_type from msdb..backupmediafamily where media_set_id = (select media_set_id from msdb..backupset where backup_set_id = 3664)

it just repeats until it exhusts its options.
Is there a way to clean up or speed up this process?

 

[mrdenny]

You would have to delete the backup history for the database from the backup history tables. What it's doing turning this time, it pulling up all the information that it needs for the drop down menus in the GUI that pops up.

If you know the name of the backup file that you want to restore you can run the restore by hand in query analyser by using the RESTORE DATABASE command.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[abuchan]

Thanks that is exactly the suggestion I needed.

 

[mrdenny]

no problem.

Denny

--Anything is possible. All it takes is a little research. (Me)