Hi,
Can I take a transaction log backup after executing "Backup log dbname with Truncate_only" script on db.
If I take a transaction log backup, is it guarenteed that whatever matter (changes or required logical log) what was there before executing the stmt will be there after executing the stmt.
There should not be any loss of logical log which will create problem if restored.
Please check & let me know the consequences of "backup log..." stmt.
Thanks in advance.
Shubhangi
Can I take a transaction log backup after executing "Backup log dbname with Truncate_only" script on db.
If I take a transaction log backup, is it guarenteed that whatever matter (changes or required logical log) what was there before executing the stmt will be there after executing the stmt.
There should not be any loss of logical log which will create problem if restored.
Please check & let me know the consequences of "backup log..." stmt.
Thanks in advance.
Shubhangi