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

Table level Restore in SQL?

Keithr73
Not applicable

‎03-01-2005 04:49 PM

Can back up and restore a complete database, but it appears that I do not have the options to restore individual tables inside the database. Is there a way to restore at the table level?

Using the SQL agent with 9.1 -even tried the new 10.0 version.


Thanks,
Keith
0 Kudos
3 REPLIES 3

Ian_Mcmaugh
Level 3

‎03-01-2005 07:54 PM

I have never tried to do this myself, as it is too dangerous.

Most likely the reason BackupExec doesnt allow you to do this is because it will mess up any indexes/triggers you have on that table.

Try to create a temporary database and restore the database into the temprorary. Then backup and restore the table from the temporary database using SQL Enterprise Manager or T-SQL.
0 Kudos

Darpan_Thaker
Level 5

‎03-14-2005 01:41 AM

Backup Exec backup the SQL server via databases and file groups. Therefore, currently it does not support the restore of individual tables from SQL database.

As rightly mentioned by Ian, you can perform the redirect restore of database to temporary database and then use the SQL utilities to import or export the tables.
0 Kudos

Abhinav_Bindroo
Level 6

‎03-19-2005 02:11 AM

Assuming the solution provided is correct. Also, there is no response from the customer within 2 days from the last reply by Veritas
0 Kudos