Two logs files for a single databaseIs there a performance benefit to placing transaction log files on a...
Multiple null checks in Java 8
How does holding onto an active but un-used credit card affect your ability to get a loan?
Disk space full during insert, what happens?
How can I give a Ranger advantage on a check due to Favored Enemy without spoiling the story for the player?
What happens if both players misunderstand the game state until it's too late?
Why don't you get burned by the wood benches in a sauna?
Why don't programs completely uninstall (remove all their files) when I remove them?
Sed-Grep-Awk operations
How to deal with an underperforming subordinate?
Protagonist constantly has to have long words explained to her. Will this get tedious?
Why is Shelob considered evil?
What could cause an entire planet of humans to become aphasic?
What is an efficient way to digitize a family photo collection?
Canadian Visa by land
Graphical modeler calculator missing in QGIS3
Does しかたない imply disappointment?
Do the speed limit reductions due to pollution also apply to electric cars in France?
bash aliases do not expand even with shopt expand_aliases
How to make transparent background from pdf to png
Is it possible to detect 100% of SQLi with a simple regex?
What does @ mean in a hostname in DNS configuration?
How to purchase a drop bar bike that will be converted to flat bar?
Why write a book when there's a movie in my head?
How many copper coins fit inside a cubic foot?
Two logs files for a single database
Is there a performance benefit to placing transaction log files on a separate drive?SQL Server 2008 R2 : multiple files and filegroupMultiple SQL Server data files on same SAN diskSingle Virtual Drive Vs Multiple Virtual Drives for SQL Server filesDatabase with multiple .mdf filesSQL Server Storage for multiple data filescurious case of two log files in sql databaseSQL Server seperate data filesMultiple filegroups vs. multiple files in a single filegroupTempdb ndf files on different drives
Is there any reason or performance benefit in having two log files for a single database and in different drives?
sql-server
asked 7 mins ago
Andres ArangoAndres Arango
132
add a comment |
Is there any reason or performance benefit in having two log files for a single database and in different drives?
sql-server
asked 7 mins ago
Andres ArangoAndres Arango
132
add a comment |
Is there any reason or performance benefit in having two log files for a single database and in different drives?
sql-server
asked 7 mins ago
Andres ArangoAndres Arango
132
Is there any reason or performance benefit in having two log files for a single database and in different drives?
sql-server
sql-server
asked 7 mins ago
Andres ArangoAndres Arango
132
asked 7 mins ago
Andres ArangoAndres Arango
132
asked 7 mins ago
Andres ArangoAndres Arango
132
asked 7 mins ago
Andres ArangoAndres Arango
132
asked 7 mins ago
Andres ArangoAndres Arango
132
132
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Logs are written to sequentially, so only one would ever be used at a time. So, no, there is no benefit from having two on the same database.
EDIT: I looked over the part about different drives. I suppose there could be a need in having two log files if you are working with limited drive space and your original log file would outgrow it's drive and you cannot move it to a larger drive for whatever reason.
answered 5 mins ago
PadwanPadwan
1365
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230517%2ftwo-logs-files-for-a-single-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Logs are written to sequentially, so only one would ever be used at a time. So, no, there is no benefit from having two on the same database.
EDIT: I looked over the part about different drives. I suppose there could be a need in having two log files if you are working with limited drive space and your original log file would outgrow it's drive and you cannot move it to a larger drive for whatever reason.
answered 5 mins ago
PadwanPadwan
1365
add a comment |
Logs are written to sequentially, so only one would ever be used at a time. So, no, there is no benefit from having two on the same database.
EDIT: I looked over the part about different drives. I suppose there could be a need in having two log files if you are working with limited drive space and your original log file would outgrow it's drive and you cannot move it to a larger drive for whatever reason.
answered 5 mins ago
PadwanPadwan
1365
add a comment |
Logs are written to sequentially, so only one would ever be used at a time. So, no, there is no benefit from having two on the same database.
EDIT: I looked over the part about different drives. I suppose there could be a need in having two log files if you are working with limited drive space and your original log file would outgrow it's drive and you cannot move it to a larger drive for whatever reason.
answered 5 mins ago
PadwanPadwan
1365
Logs are written to sequentially, so only one would ever be used at a time. So, no, there is no benefit from having two on the same database.
EDIT: I looked over the part about different drives. I suppose there could be a need in having two log files if you are working with limited drive space and your original log file would outgrow it's drive and you cannot move it to a larger drive for whatever reason.
answered 5 mins ago
PadwanPadwan
1365
answered 5 mins ago
PadwanPadwan
1365
answered 5 mins ago
PadwanPadwan
1365
answered 5 mins ago
PadwanPadwan
1365
1365
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230517%2ftwo-logs-files-for-a-single-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
