question

sreekanth99 avatar image
sreekanth99 asked

IS ddl opertions are loggged in log file or not?what ddl operations logged?

IS ddl opertions are loggged in log file or not?what ddl operations logged? create index,alter index,rebulid is logged or not
ddl-changes
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
Everything gets logged so that when you do a point in time recovery by restoring log files, you're able to recreate the database into the state it was at the time the log backups were taken. Otherwise, you could only ever take full backups.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.