Can someone please tell me how to create multiple instances for a single database?

Also, please let me know in what way it could be an advantage/dis advantage?