Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-27 : 12:39:47
|
| Haroon writes "Q.1). I create a new database. In my SQL statement to create the database, I specify two log files be created for my database. How will SQL Server use these files? Will it use them both in parallel or would it use one file until it gets filled up and then shift onto the other one and start filling it up? If I also specify the file growth options for both of these log files, then if one file gets filled up, will it be extended to be used further? or will SQL Server stop using it and continue with the second one?Q.2). The same case of Q1 with the Data Files (i.e. Primary and Secondary Data Files)." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-27 : 12:46:00
|
| I believe that for the logs, SQL Server will use the second file only when the first file has filled up. But for data files, you specify which tables go on which data files. Then all data modifications to that table would occur on the data file that was specified on the create statement of the table. |
 |
|
|
|
|
|
Log Files and Data Files