| Microsoft usually urges that you should use a SAN | | | | recovery logic, that ensure database integrity and |
| (Storage Area Network) or locally attached hard | | | | consistency in case of system failure or improper |
| drive to store MS SQL Server database (MDF) files | | | | system shutdown. |
| as this configuration improves SQL Server reliability | | | | These SQL Server Recovery protocols bank on the |
| and performance. Use of network database (stored | | | | capability to write instantly on the hard drive media |
| on network server or NAS [Network Attached | | | | so that if any operating system I/O (Input/Output) |
| Server]) is disabled by default in Microsoft SQL | | | | write call returns to database manage, recovery |
| Server. In order to ensure complete data safety and | | | | system is assured that write operation is really |
| to prevent need of SQL Database Recovery, you | | | | complete or the completion of write process can be |
| should not use SQL Server database on networked | | | | ensured. Any type of failure by any hardware or |
| server. | | | | software components of this protocol may result in |
| Though, it is not recommended, but it is possible to | | | | complete or partial data loss due to corruption of |
| configure MS SQL Server for storing the database on | | | | MDF file. |
| a NAS storage server or networked server. Data | | | | In such critical circumstances, you need to restore |
| storage servers, that are employed to store MDF | | | | the damaged database from the most recent |
| database, must meet the SQL Server needs for | | | | backup. However, if the backup is either not available |
| 'write-through guarantees' and 'data write ordering'. | | | | or not updated, third-party MS SQL Recovery |
| If you try to create SQL Server database file on | | | | software is the only way to go. |
| UNC or mapped network location results into any of | | | | The MS SQL Recovery applications are powerful |
| the below error message: | | | | enough to carry out in-depth scan of entire SQL |
| 5105 "Device Activation Error" | | | | Server database and extract all inaccessible database |
| Or | | | | objects. With the read-only and simple graphical user |
| 5110 "File 'file_name' is on a network device not | | | | interface, they are completely safe and easy to use. |
| supported for database files." | | | | SQL Recovery is the most prominent tool that |
| The above behavior is quite expected. The trace flag | | | | enables absolute recovery in all cases of MDF |
| 1807 let you to bypass the check process and | | | | corruption. It restores all database objects such as |
| enables you to configure MS SQL Server with the | | | | tables, reports, forms, modules, queries, constraints, |
| networked database files. Microsoft SQL Server and | | | | stored procedures, and triggers. The software is |
| various other relational database management | | | | compatible with MS SQL Server 2008, 2005, and |
| systems use the transaction log and associated | | | | 2000. |