SQL Server transaction log ldf file
How can I delete the data in the log file (.ldf)? I've already tried a backup, compact, but stellarinfo software retrieves deleted records.
sql
sql-server logging ldf edited Oct 10 '17 at 11:45
marc_s
580k13011191266
asked Oct 10 '17 at 10:44
user8750909user8750909
62
add a comment |
How can I delete the data in the log file (.ldf)? I've already tried a backup, compact, but stellarinfo software retrieves deleted records.
sql
sql-server logging ldf edited Oct 10 '17 at 11:45
marc_s
580k13011191266
asked Oct 10 '17 at 10:44
user8750909user8750909
62
add a comment |
How can I delete the data in the log file (.ldf)? I've already tried a backup, compact, but stellarinfo software retrieves deleted records.
sql
sql-server logging ldf edited Oct 10 '17 at 11:45
marc_s
580k13011191266
asked Oct 10 '17 at 10:44
user8750909user8750909
62
How can I delete the data in the log file (.ldf)? I've already tried a backup, compact, but stellarinfo software retrieves deleted records.
sql
sql-server logging ldf sql
sql-server logging ldf edited Oct 10 '17 at 11:45
marc_s
580k13011191266
asked Oct 10 '17 at 10:44
user8750909user8750909
62
edited Oct 10 '17 at 11:45
marc_s
580k13011191266
asked Oct 10 '17 at 10:44
user8750909user8750909
62
edited Oct 10 '17 at 11:45
marc_s
580k13011191266
edited Oct 10 '17 at 11:45
marc_s
580k13011191266
edited Oct 10 '17 at 11:45
marc_s
580k13011191266
580k13011191266
asked Oct 10 '17 at 10:44
user8750909user8750909
62
asked Oct 10 '17 at 10:44
user8750909user8750909
62
asked Oct 10 '17 at 10:44
user8750909user8750909
62
62
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
You said
software retrieves deleted records
If you can query "deleted" records, it means they were not deleted.
The data is still there
The transation log does not store any data, it basically stored a record of what happened so it can be replayed or rolled back. You can't "delete data" from the transation log (ldf) file.
It is that simple
answered Oct 10 '17 at 11:06
gbngbn
345k58487578
add a comment |
Except MDF file SQL Server also maintain the records in .ldf file which keeps the data in a form of transaction log. which a database user cannot view or edit directly. each time you Insert, Update, delete records in SQL Server, these transactions maintained in .ldf file on the basis of LSNs for future use.
However, you can use fn_dblog() function to read SQL Server transaction log or use a third party tool better understand the .ldf file and read SQL Server transaction logs.
edited Nov 15 '18 at 11:42
Martijn Pieters♦
717k13925042319
answered Oct 11 '17 at 9:24
Jason ClarkJason Clark
10441434
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f46664754%2fsql-server-transaction-log-ldf-file%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You said
software retrieves deleted records
If you can query "deleted" records, it means they were not deleted.
The data is still there
The transation log does not store any data, it basically stored a record of what happened so it can be replayed or rolled back. You can't "delete data" from the transation log (ldf) file.
It is that simple
answered Oct 10 '17 at 11:06
gbngbn
345k58487578
add a comment |
You said
software retrieves deleted records
If you can query "deleted" records, it means they were not deleted.
The data is still there
The transation log does not store any data, it basically stored a record of what happened so it can be replayed or rolled back. You can't "delete data" from the transation log (ldf) file.
It is that simple
answered Oct 10 '17 at 11:06
gbngbn
345k58487578
add a comment |
You said
software retrieves deleted records
If you can query "deleted" records, it means they were not deleted.
The data is still there
The transation log does not store any data, it basically stored a record of what happened so it can be replayed or rolled back. You can't "delete data" from the transation log (ldf) file.
It is that simple
answered Oct 10 '17 at 11:06
gbngbn
345k58487578
You said
software retrieves deleted records
If you can query "deleted" records, it means they were not deleted.
The data is still there
The transation log does not store any data, it basically stored a record of what happened so it can be replayed or rolled back. You can't "delete data" from the transation log (ldf) file.
It is that simple
answered Oct 10 '17 at 11:06
gbngbn
345k58487578
answered Oct 10 '17 at 11:06
gbngbn
345k58487578
answered Oct 10 '17 at 11:06
gbngbn
345k58487578
answered Oct 10 '17 at 11:06
gbngbn
345k58487578
345k58487578
add a comment |
add a comment |
Except MDF file SQL Server also maintain the records in .ldf file which keeps the data in a form of transaction log. which a database user cannot view or edit directly. each time you Insert, Update, delete records in SQL Server, these transactions maintained in .ldf file on the basis of LSNs for future use.
However, you can use fn_dblog() function to read SQL Server transaction log or use a third party tool better understand the .ldf file and read SQL Server transaction logs.
edited Nov 15 '18 at 11:42
Martijn Pieters♦
717k13925042319
answered Oct 11 '17 at 9:24
Jason ClarkJason Clark
10441434
add a comment |
Except MDF file SQL Server also maintain the records in .ldf file which keeps the data in a form of transaction log. which a database user cannot view or edit directly. each time you Insert, Update, delete records in SQL Server, these transactions maintained in .ldf file on the basis of LSNs for future use.
However, you can use fn_dblog() function to read SQL Server transaction log or use a third party tool better understand the .ldf file and read SQL Server transaction logs.
edited Nov 15 '18 at 11:42
Martijn Pieters♦
717k13925042319
answered Oct 11 '17 at 9:24
Jason ClarkJason Clark
10441434
add a comment |
Except MDF file SQL Server also maintain the records in .ldf file which keeps the data in a form of transaction log. which a database user cannot view or edit directly. each time you Insert, Update, delete records in SQL Server, these transactions maintained in .ldf file on the basis of LSNs for future use.
However, you can use fn_dblog() function to read SQL Server transaction log or use a third party tool better understand the .ldf file and read SQL Server transaction logs.
edited Nov 15 '18 at 11:42
Martijn Pieters♦
717k13925042319
answered Oct 11 '17 at 9:24
Jason ClarkJason Clark
10441434
Except MDF file SQL Server also maintain the records in .ldf file which keeps the data in a form of transaction log. which a database user cannot view or edit directly. each time you Insert, Update, delete records in SQL Server, these transactions maintained in .ldf file on the basis of LSNs for future use.
However, you can use fn_dblog() function to read SQL Server transaction log or use a third party tool better understand the .ldf file and read SQL Server transaction logs.
edited Nov 15 '18 at 11:42
Martijn Pieters♦
717k13925042319
answered Oct 11 '17 at 9:24
Jason ClarkJason Clark
10441434
edited Nov 15 '18 at 11:42
Martijn Pieters♦
717k13925042319
edited Nov 15 '18 at 11:42
Martijn Pieters♦
717k13925042319
edited Nov 15 '18 at 11:42
Martijn Pieters♦
717k13925042319
717k13925042319
answered Oct 11 '17 at 9:24
Jason ClarkJason Clark
10441434
answered Oct 11 '17 at 9:24
Jason ClarkJason Clark
10441434
answered Oct 11 '17 at 9:24
Jason ClarkJason Clark
10441434
10441434
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f46664754%2fsql-server-transaction-log-ldf-file%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
