**self-hosted**
So when I get to the "restore database" part of a Live to TEST copy, sometimes it takes 20 mins to restore but other times it take HOURS! I am not sure what could be behind this and I had never done a database restore before this role so I don't know much about it outside of this process.
Any thought or ideas about with this might be happening? Is is a space issue on my server? Could is be network speed related??
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
Not sure if your server setup would allow, but I typically restart the SQL services prior to doing a restore just to clean everything out of SQL and return its resources.