I'm having an issue with SSMS SQL Server 2014 (before and after SP1).
When I go and select 'restore database' from the server and select a database, it just sits there and spin and spins. More than 24 hours with no results during one initial test.
Test's I've done:
Tested against the same database using both SSMS 2008 R2 and 2014/SP1 both on the server and on my laptop.
Using SSMS SQL Server 2014:
7 days in MSDB backupfile 1.9 mil records didn't finish in the time I took lunch.
3 days in MSDB backupfile 767k records took 1 minute 31 seconds.
Using SSMS SQL Server 2008 R2:
90 days in msdb dbo.backupfile 6.7 mil records was instant and finished loading in less than 3 seconds.
I ran a trace while testing using both versions against both databases...
- When SSMS 2014 was executing the trace files would grow to almost 500MB...
- When SSMS 2008R2 was executing the trace file grew to 260k
I've also applied various indexes to the msdb database from other posts online. It helped a little when the records were reduced, but not enough to the desired effect.
So, in conclusion I think it might be 2014 SSMS that is the issue...thoughts?