I tried to do data refresh for one Epicor test environment with production database. After I click on Tasts>Restore>Database, SSMS takes forever to open the restore database window. This only happens to one specific database. Anyone has this issue? and please help.
Possibly backup history?
Try this post.
https://blog.sqlauthority.com/2018/05/07/sql-server-restore-database-wizard-in-ssms-is-very-slow-to-open/
I prefer to just have a bunch on scripts that I use to restore databases on an adhoc basis and just adjust the source of the backup file in the script. Restoring to a point in time is a bit more involved.
I see this when using SSMS over a vpn. My workaround is to remote desktop into a server and run SSMS from there.
It seems the VPN issue is separate from the backup history mentioned in that post. For me running SSMS locally (no VPN) opening the restore dialog for the LIVE data base is slow but it is fast for the test databases with no backup history. Over the VPN the test databases become slow.
Brett
1 Like
Why do you need the backup history if you already know where your backups are stored and transaction log files? Are you trying to do a full restore from a production backup file? What version of MS-SQL server studio are you using. I would not us the SQLserver client and just login to the server and use the SQLserver studio from the server to do the restore.
Yes, we’re trying to do a full restore from a production backup file, our MS SQL server version is 2014.
Thank you, Simon. I’ve read this post and removed some backup history but we still have this issue.
Are you doing the restore on the server using SQL Server 2014 Studio?
Reference EpicWeb document KB0028569 - SQL How do I copy my production database to test slot?
AnswerBook # 16757MPS - Last updated on 12/06/2016.
Thank you, Mazin. Yes, I was doing the restore on the server using SQL Server Management Studio.
I RDP to the server and run the SSMS on the server. Thanks.
how big is your backup?
Can you take another backup and try to restore?
I open up EPICOR Admin, stop App Pool for AppServer (TEST)
I open up SSMS, copy name of DB, delete DB (TEST)
Restore File and Filegroups
Enter old DB name (TEST)
Click devices and search.
My E9 Progress was converted and I have it as a back up. restored it is huge. so it takes awhile to restore.
Thank you all for your help and info. I am going to run T-SQL scripts to restore the database.