<div>
No Vitor. We are not taking any T-log backup only Full backup if onlly NBU backups failed.
</div>


No Vitor. We are not taking any T-log backup only Full backup if onlly NBU backups failed.

<div>
Without transaction lg backup, you forgo the restore to a specific time. Making the potential loss the largest amount of time between full backups.<br />
<br />
I.e. Five minutes before the current scheduled full backup an errand run corrupts data, the restore will be to the last prior backup.<br />
<br />
To maximize data protection, one should use a combination of full backups and transaction log backups.<br />
<br />
You shoukd test using a test server with SQL, and restore e DB from the backups you have.
</div>


Without transaction lg backup, you forgo the restore to a specific time. Making the potential loss the largest amount of time between full backups.

I.e. Five minutes before the current scheduled full backup an errand run corrupts data, the restore will be to the last prior backup.

To maximize data protection, one should use a combination of full backups and transaction log backups.

You shoukd test using a test server with SQL, and restore e DB from the backups you have.

<div>
<div class="content wysiwyg-content">
Hi Team,<br />
<br />
<br />
Is it possible to restore below combination of backups?<br />
Full backup performed by T-SQL and Log backup performed by Symantec Net Backup (NBU)<br />
<br />
The reason is, in my organization we are using Netbackup for all SQL servers (Weekly Full/Daily Log)<br />
If any backup (Full) fails, just we are using T-SQL for that. In case can i restore T-SQL full backup and NBU log backup?
</div>
</div>


Hi Team,


Is it possible to restore below combination of backups?
Full backup performed by T-SQL and Log backup performed by Symantec Net Backup (NBU)

The reason is, in my organization we are using Netbackup for all SQL servers (Weekly Full/Daily Log)
If any backup (Full) fails, just we are using T-SQL for that. In case can i restore T-SQL full backup and NBU log backup?

Backup and Restore SQL Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.