Hi.
The company I'm working for uses SQL Server with their ERP software. I've been working with a (now outdated) backup, doing some development. Last week I decided to get a "fresher" copy.
When I restore this backup, I can't select it from the dropdown menu (Available databases). If I click it's name, my instance crashes and the database goes into recovery mode. I can wait and run a query like "select top 10 * from [BACKUP_DB].[dbo].[item]
but if I write it char by char, when I get to .[dbo]., SSMS "hangs" and takes a really long time to recover. After that I can run the query...
I've tried a new backup this morning and restoring it in a virtual machine with a freshly installed instance, but I have similar issues.
I've run:
SELECT Go to the complete details ...