January 14, 2013 at 11:34 pm
Would like to know whether DCL and DDL statements are logged in sql log file before hardening on data file?
can any one detail me abt log file and logs.
January 14, 2013 at 11:52 pm
DDL statements are logged in Server Log
beside this you can also refer this link for additional information
http://msdn.microsoft.com/en-us/library/ms180892(v=sql.105).aspx
January 15, 2013 at 1:16 am
sej2008 (1/14/2013)
Would like to know whether DCL and DDL statements are logged in sql log file before hardening on data file?
DCL?
All modifications to the database are logged first before the changes may be written to the data file. Google: write-ahead logging.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply