September 9, 2014 at 5:57 am
Hi All,
Could anyone please help me to get answer for the below point.
1)what is sql server network architecture
2) what is Active log in sql server
3) Transaction log-logical and physical log
Thanks in advance
September 11, 2014 at 8:44 am
Hi arooj,
First Question: http://sqldbasupport.wordpress.com/2009/07/21/sql-server-architecture/
Second Question: The portion of the log file from the MinLSN to the last-written log record is called the active portion of the log.
Third Question: Every SQL Server database has a transaction log that records all transactions and the database modifications made by each transaction.
I think a better read then my answers above would be at msdn here: http://technet.microsoft.com/en-us/library/aa174526(v=sql.80).aspx
Hope that gets you started!
Kind Regards,
Jeremy
September 12, 2014 at 9:09 am
nice link.
its very helpful for me.
Thank you very much
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply