...
SQL Server databases are primarily backed by two categories of files – | Newtablink |
|---|
alias | data files| url | http://technet.microsoft.com/en-us/library/ms179316(v=sql.105).aspx |
|---|
and and | Newtablink |
|---|
| alias | log files |
|---|
| url | http://technet.microsoft.com/en-us/library/ms190925.aspx |
|---|
|
. The data files contain all of the data related to the database, including tables, indexes, and object definitions, while the log files contain a log of all of the changes which have been made to that data. This separation of log and data files is critical to ensuring the recoverability of the data in the case of an unexpected server failure.
...