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. Data files are further subdivided into primary and secondary data files, which can be grouped into collections called filegroups.
...