adspace


Does sql full backup truncate logs?

Answer Posted / Arti

No, a SQL Full Backup does not truncate transaction logs. It captures the state of all data files at a specific point in time, while transaction logs continue to record database changes.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key clustered index?

1019


what is dbms? : Sql dba

1061


Can delete statement be rollbacked?

1054


what is bcp? When does it used? : Sql dba

1056


Do we need to rebuild index after truncate?

1138


what are aggregate and scalar functions? : Sql dba

1129


How do I remove duplicates in two columns?

1187


Does group by remove duplicates?

1112


how to escape special characters in sql statements? : Sql dba

1114


What is your daily office routine?

2346


define sql insert statement ? : Sql dba

1098


what are the advantages of sql ? : Sql dba

1142


how many tables will create when we create table, what are they? : Sql dba

1144


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2091


If a cursor is open, how can we find in a pl/sql block?

1238