MS SQL Server Tools - Restore Dialog Box Won't Open

Author

Restore Dialog Box Won't Open

John Oberlin

2006-01-10, 1:23 pm

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

Tibor Karaszi

2006-01-10, 1:23 pm

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/

"John Oberlin" < JohnOberlin@discussi
ons.microsoft.com> wrote in message
news:24CDCFE5-604C-4D08-8E1A- E8A1B1AFA884@microso
ft.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

John Oberlin

2006-01-12, 8:24 pm

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_backuphist
ory '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

Sponsored Links