February 11, 2009 at 4:01 pm
Good afternoon, In a production system in order to make a backup of certain information in a table called X, data is downloaded to a flat plane, and then bakup. If the data from the table X being backed up didnt backed up completely, and after that data was deleted from the table X, our DBA says in order to restore tha data from the table needs to restore all database and needs so much space for the server.
Anyway, the question is: ¿in order to restore data from a single table (x), need to restore all or the entire database and why? or that depends on the objects being involved in a database?
I appreciate your help, Thanks a lot
February 11, 2009 at 4:18 pm
Since you don't have a complete backup of table X and the data was deleted he can't load\restore from that file.
Sql Server 7 and up doesn't not support table level restores. It sounds like your DBA has a full backup of the database so to get back table X he needs to restore the entire database.
Restoring to a alternate location, getting a diff of data and then loading the difference is possible. However this is HIGHLY dependant on your environment, the transactional nature of the data, the ability to get a good diff and other factors.
Sounds like you have a good admin and he is giving you the options available.
David
February 23, 2009 at 1:02 pm
As mentioned, SQL Server doesn't support single object restore. There are some third party products that do handle this, like SQLBackup (Red Gate), SQLCompare, Lightspeed (Quest)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply