SQL 2012 - Add File Location Long Delay

I am using SQL Server 2012 and I am trying to restore a database. When I try to select a Device and click the Browse icon to Add a File Location, the file browsing window takes up to 5 minutes to appear.
Is there a fix for this or something that needs to be updated?

Please advise.

Thanks.
JJENSEN3Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
JJENSEN3Connect With a Mentor Author Commented:
The problem turned out to be firmware issues with the HP hardware. Once updated, the disk response improved.
0
 
David ToddSenior DBACommented:
Hi,

Is the actual restore okay?

How full are the disks?

Regards
  David
0
 
JJENSEN3Author Commented:
Restores are fine. 100gb used on 1TB of disk.
0
 
Scott PletcherSenior DBACommented:
It's very likely because there's a lot of backup history in msdb.  You need to clean out the obsolete data, like so:

EXEC msdb.dbo.sp_delete_backuphistory 'YYYYMMDD' --<<--delete everything before this date


Btw, you should learn to do restores using the

RESTORE DATABASE

command, because it would allow you to pre-code and verify all the restore info before running.  And it lets you repeat a restore very easily and accurately.
0
 
JJENSEN3Author Commented:
It worked
0
All Courses

From novice to tech pro — start learning today.