I am quite new in terms of SQL Server. I tried to search but can't really find any topic related on what I asked, or probably I didn't phrase my search term correctly. Here is what I am trying to figure out:
in SQL Server 2012, Is it possible to have two different database instance but stored in different Harddrive? For example, I have SQL Server "MSSQLSERVER".
I will have 2 database that are mirror of each other. The database will be database A and database B.
I want to have database A to be stored in D: drive, and database B to be stored in E: drive, but when I write into database A, it will automatically synch into database B as well.
I want this to be in 1 server and I am not planning to use RAID for the HDD. I only want to have database B as my backup in case one HDD failed.