Restoring SQL DB from down SQL Server (on domain) to existing SQL server (not on domain) If and when my SQL server goes down and takes too long to get back up, can I restore my DB on another SQL server and run my software from there (I can point which SQL server to run from)?

Will all metadata and indexes and foreign keys be restored too?

Also my current SQL server is on our domain, the other one I have is on its own workgroup... Would it still be possible? Or would I need to join it to the domain first?
Restoring a SQL Server database only requires admin rights to the destination SQL Server instance.  It doesn't matter at all if the new or old machines were members of the domain.