Restore Dialog Box Won't Open

10 Jan 2006 5:50 PM

John Oberlin

I am trying to restore a particular database in Enterprise Manager and the
restore dialog box won't open. I right-click the database and select All
Tasks >> Restore Database... Enter. Mgr sits at an hour glass 'not
responding' until I end task. All Tasks >> Backup and All Tasks >> Shrink
work fine. Other databases work fine. Running Enter Mgr from another client
behaves the same way.
Windows 2000 Server SP4
SQL 2000 SP3

10 Jan 2006 5:54 PM

Tibor Karaszi

My guess is that you have a *lot* of backup history for this database. Search the archives for tips
and tricks to trim backuphistory.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"John Oberlin" <JohnOber***@discussions.microsoft.com> wrote in message
news:24CDCFE5-604C-4D08-8E1A-E8A1B1AFA884@microsoft.com...
>I am trying to restore a particular database in Enterprise Manager and the
> restore dialog box won't open. I right-click the database and select All
> Tasks >> Restore Database... Enter. Mgr sits at an hour glass 'not
> responding' until I end task. All Tasks >> Backup and All Tasks >> Shrink
> work fine. Other databases work fine. Running Enter Mgr from another client
> behaves the same way.
> Windows 2000 Server SP4
> SQL 2000 SP3

12 Jan 2006 9:20 PM

John Oberlin

Hi Tibor,

Thanks for the guidance - you were right on. I discovered if I left it for
45 min. the restore window would eventually open. I ran the following stored
proc.

EXEC sp_delete_backuphistory '12/10/05'

This kept a month's worth of backup history. The backup tables went from
having upwards of 280,000 rows down to less than 6,000. Apparently tlog
backups had been running every 15 min. for a few years.

Thanks again,
John