It is not uncommon to have multiple copies of the same database on a single instance or to restore copy of a database from one instance to another for testing.   I was asked - “How does this work when I have filestream data in my database?”   ...read more