Showing posts with label logfiles. Show all posts
Showing posts with label logfiles. Show all posts

Monday, March 26, 2012

Log Files

Hello All,
Is there anyway I can read logfiles programatically (or non-programtically
using non-third-party tools)' I need to read
logfiles to know what transaction happened to a particular record, is there
anyway'
Thanks in advance
--
Maher K. Al-Jendasi
Privacy and Confidentiality Notice:
The information contained in this electronic mail message is intended for
the named recipient(s) only. It may contain privileged and confidential
information. If you are not an intended recipient, you must not copy,
forward, distribute, or take any action in reliance on it.
If you have received this electronic mail message in error, please notify
the sender immediately.Please nto cross posting, answered in .programming.
Jens Süßmeyer.
"Maher K. Al-Jendasi" <mkaljendasi@.hotmail.com> schrieb im Newsbeitrag
news:#iwDh74eDHA.1736@.TK2MSFTNGP12.phx.gbl...
> Hello All,
> Is there anyway I can read logfiles programatically (or non-programtically
> using non-third-party tools)' I need to read
> logfiles to know what transaction happened to a particular record, is
there
> anyway'
> Thanks in advance
>
> --
> Maher K. Al-Jendasi
> Privacy and Confidentiality Notice:
> The information contained in this electronic mail message is intended for
> the named recipient(s) only. It may contain privileged and confidential
> information. If you are not an intended recipient, you must not copy,
> forward, distribute, or take any action in reliance on it.
> If you have received this electronic mail message in error, please notify
> the sender immediately.
>
>|||LogExplorer made by Lumigent (www.lumigent.com) will read the log files, and
much more.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Maher K. Al-Jendasi" <mkaljendasi@.hotmail.com> wrote in message
news:#iwDh74eDHA.1736@.TK2MSFTNGP12.phx.gbl...
> Hello All,
> Is there anyway I can read logfiles programatically (or non-programtically
> using non-third-party tools)' I need to read
> logfiles to know what transaction happened to a particular record, is
there
> anyway'
> Thanks in advance
>
> --
> Maher K. Al-Jendasi
> Privacy and Confidentiality Notice:
> The information contained in this electronic mail message is intended for
> the named recipient(s) only. It may contain privileged and confidential
> information. If you are not an intended recipient, you must not copy,
> forward, distribute, or take any action in reliance on it.
> If you have received this electronic mail message in error, please notify
> the sender immediately.
>
>

Monday, March 12, 2012

log file at sql server shutdown

hi all,
maybe a poor question, but i cannot test it for myself now.
when i shutdown or stop sql server, will there all logfiles be written in
the databasefiles, the same as a backup will do?
thanks for help
jeffHi
It depends on how orderly the shutdown is, in an orderly shutdown a
checkpoint is carried out which will write all dirty pages to disc.
Check out:
rt_6628.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
rt_6628.asp
or
_4hk5.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
_4hk5.asp
241g.asp" target="_blank">http://msdn.microsoft.com/library/d...br />
241g.asp
On restarting SQL server will try and recover any committed transactions
from the log file.
John
"j.goines" wrote:

> hi all,
> maybe a poor question, but i cannot test it for myself now.
> when i shutdown or stop sql server, will there all logfiles be written in
> the databasefiles, the same as a backup will do?
> thanks for help
> jeff
>
>|||thanks a lot!
jeff
"John Bell" <jbellnewsposts@.hotmail.com> schrieb im Newsbeitrag
news:2706FFFE-4BD4-42EC-8465-18A7569B8F60@.microsoft.com...[vbcol=seagreen]
> Hi
> It depends on how orderly the shutdown is, in an orderly shutdown a
> checkpoint is carried out which will write all dirty pages to disc.
> Check out:
> tart_6628.asp" target="_blank">http://msdn.microsoft.com/library/d...
tart_6628.asp
> or
> te_4hk5.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
te_4hk5.asp
> o_241g.asp" target="_blank">http://msdn.microsoft.com/library/d... />
o_241g.asp
> On restarting SQL server will try and recover any committed transactions
> from the log file.
> John
> "j.goines" wrote:
>

log file at sql server shutdown

hi all,
maybe a poor question, but i cannot test it for myself now.
when i shutdown or stop sql server, will there all logfiles be written in
the databasefiles, the same as a backup will do?
thanks for help
jeff
Hi
It depends on how orderly the shutdown is, in an orderly shutdown a
checkpoint is carried out which will write all dirty pages to disc.
Check out:
http://msdn.microsoft.com/library/de...start_6628.asp
or
http://msdn.microsoft.com/library/de...reate_4hk5.asp
http://msdn.microsoft.com/library/de...ca-co_241g.asp
On restarting SQL server will try and recover any committed transactions
from the log file.
John
"j.goines" wrote:

> hi all,
> maybe a poor question, but i cannot test it for myself now.
> when i shutdown or stop sql server, will there all logfiles be written in
> the databasefiles, the same as a backup will do?
> thanks for help
> jeff
>
>
|||thanks a lot!
jeff
"John Bell" <jbellnewsposts@.hotmail.com> schrieb im Newsbeitrag
news:2706FFFE-4BD4-42EC-8465-18A7569B8F60@.microsoft.com...[vbcol=seagreen]
> Hi
> It depends on how orderly the shutdown is, in an orderly shutdown a
> checkpoint is carried out which will write all dirty pages to disc.
> Check out:
> http://msdn.microsoft.com/library/de...start_6628.asp
> or
> http://msdn.microsoft.com/library/de...reate_4hk5.asp
> http://msdn.microsoft.com/library/de...ca-co_241g.asp
> On restarting SQL server will try and recover any committed transactions
> from the log file.
> John
> "j.goines" wrote:

log file at sql server shutdown

hi all,
maybe a poor question, but i cannot test it for myself now.
when i shutdown or stop sql server, will there all logfiles be written in
the databasefiles, the same as a backup will do?
thanks for help
jeffHi
It depends on how orderly the shutdown is, in an orderly shutdown a
checkpoint is carried out which will write all dirty pages to disc.
Check out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_start_6628.asp
or
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_4hk5.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_241g.asp
On restarting SQL server will try and recover any committed transactions
from the log file.
John
"j.goines" wrote:
> hi all,
> maybe a poor question, but i cannot test it for myself now.
> when i shutdown or stop sql server, will there all logfiles be written in
> the databasefiles, the same as a backup will do?
> thanks for help
> jeff
>
>|||thanks a lot!
jeff
"John Bell" <jbellnewsposts@.hotmail.com> schrieb im Newsbeitrag
news:2706FFFE-4BD4-42EC-8465-18A7569B8F60@.microsoft.com...
> Hi
> It depends on how orderly the shutdown is, in an orderly shutdown a
> checkpoint is carried out which will write all dirty pages to disc.
> Check out:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_start_6628.asp
> or
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_4hk5.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_241g.asp
> On restarting SQL server will try and recover any committed transactions
> from the log file.
> John
> "j.goines" wrote:
>> hi all,
>> maybe a poor question, but i cannot test it for myself now.
>> when i shutdown or stop sql server, will there all logfiles be written in
>> the databasefiles, the same as a backup will do?
>> thanks for help
>> jeff
>>