title: How to maintain database in a separate (portable) SQL file?
body: <p>I am creating an application for some user to maintain records in database. For this, I'll have to write SQL query (C#) and create the database, if does not exist, when user starts/installs the application. To make the creation and backup procedure easier, I want to create a separate file for SQL Server that will be used to store data. This file will be included in installation pack and copied to the destination folder to be used by SQL Server.</p>
  
  <p>I've seen that we can create such file but never used like this.
  Is it possible to accomplish the job I am trying to do?</p>