March 24, 2015 at 12:36 pm
I have SQL 2014. When I try to restore a user database using SSMS GUI, the Restore Database Pop up box never pops up. This happens for any database on this server at any time. Sometimes I get the pop up, some times I dont get.
So I tried to click on Databases on Top and Restore Database, and then select the db that I need to restore from Drop down, then it shows "creating restore plan selecting backups" but it takes forever.
We have full backup and trn log backups every 30 mins. So is it trying to get all these backup files in the background causing this issue? If yes then how to overcome this?
Please let me know Thanks
March 24, 2015 at 12:49 pm
dallas13 (3/24/2015)
I have SQL 2014. When I try to restore a user database using SSMS GUI, the Restore Database Pop up box never pops up. This happens for any database on this server at any time. Sometimes I get the pop up, some times I dont get.So I tried to click on Databases on Top and Restore Database, and then select the db that I need to restore from Drop down, then it shows "creating restore plan selecting backups" but it takes forever.
We have full backup and trn log backups every 30 mins. So is it trying to get all these backup files in the background causing this issue? If yes then how to overcome this?
Please let me know Thanks
If I got this right then the first thought would be to add differential backups into the schedule, next would be to not to use the GUI.
😎
March 24, 2015 at 12:53 pm
Thanks but we can not add diff backup in our environment. thats how this environment is since sql 2005, 2008 and now 2014 is the only one that started giving the issue.
Of course when it never pops up I have to use script to restore but is this a known problem or just happening with me?
March 24, 2015 at 1:23 pm
dallas13 (3/24/2015)
Thanks but we can not add diff backup in our environment. thats how this environment is since sql 2005, 2008 and now 2014 is the only one that started giving the issue.Of course when it never pops up I have to use script to restore but is this a known problem or just happening with me?
The GUI has yet to catch up with the functionality, my take on it is to use it as a "short-cut" for trivial ad hoc tasks but not for any "serious" work.
😎
March 24, 2015 at 4:38 pm
I don't use the GUI much myself, but I demo it regularly and I've had to use it for screen captures and other functions. I haven't had problems with it in 2014. Check to see if you've applied the cumulative updates to your machine as well as the server.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply