asked on
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.
Is there a fix for this or something that needs to be updated?
Please advise.
Thanks.
Microsoft SQL ServerWindows Server 2012
Last Comment
JJENSEN3
ASKER
Restores are fine. 100gb used on 1TB of disk.
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_backuph
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.
EXEC msdb.dbo.sp_delete_backuph
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.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
It worked
Is the actual restore okay?
How full are the disks?
Regards
David