cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

Restoring single table in sql.

Go to solution
kumar_n
Level 2
Partner

‎05-14-2011 05:50 AM

Is it possible with BES 2010 to restore single table of sql2000 /2005 database? Assuming one is usiong sql agent for backup and sql is on a ohysical hardware?is GRT helpful in this case?

 

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions

Go to solution
pkh
Moderator
Moderator
   VIP    Certified

‎05-14-2011 07:38 PM

 

There is no point in restoring a single table for a SQL database because you could end up with an inconsistent database.  A SQL transaction may span a couple of tables.  Restoring one table would mean an incomplete transaction and thus an inconsistent database.
 
The smallest granularity that you can do when restoring a SQL database is a point-in-time restore.  Note that BE calls the SQL Server API to do its restore and any limitation to the restore is imposed by SQL Server and not BE.

View solution in original post

0 Kudos
2 REPLIES 2

Go to solution
AmolB
Moderator
Moderator
Employee Accredited Certified

‎05-14-2011 09:55 AM

Its not possible to restore a single table.

Similar issue https://www-secure.symantec.com/connect/forums/how-restore-single-sql-table-using-backup-exec-86

0 Kudos

Go to solution
pkh
Moderator
Moderator
   VIP    Certified

‎05-14-2011 07:38 PM

 

There is no point in restoring a single table for a SQL database because you could end up with an inconsistent database.  A SQL transaction may span a couple of tables.  Restoring one table would mean an incomplete transaction and thus an inconsistent database.
 
The smallest granularity that you can do when restoring a SQL database is a point-in-time restore.  Note that BE calls the SQL Server API to do its restore and any limitation to the restore is imposed by SQL Server and not BE.
0 Kudos