In which folder should I save my MSSQL database if I'm using Apache and PHP?

Answer 1

You need mssql running somewhere, and the server needs to be configured to use whatever database files you have. This has nothing to do with apache or php -- mssql is a server that PHP can talk to through a PHP extension or PDO. PHP doesn't know or care where the individual mssql database files are. You really need a dba or developer who really understands how mssql works to get things up and running for you. In general databases aren't single files that you can save and move like an excel spreadsheet --- they are complicated servers that use an array of different files. Moving data from one to another often involves backup/restore or import/export type operations. Mssql like many relational databases has a data dictionary with all sorts of information about the objects (tables/indexes/stored procs, etc) inside the database, so it's not as simple as copying.