[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

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.
0
JJENSEN3
Asked:
JJENSEN3
  • 3
1 Solution
 
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:
The problem turned out to be firmware issues with the HP hardware. Once updated, the disk response improved.
0
 
JJENSEN3Author Commented:
It worked
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now