Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

Tip of the Day
Language: SQL Server
Expertise: Beginner
Oct 26, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Restoring Tables

Does SQL 7.0 allow you to restore a table from a database dump much the way SQL 6.5 did?

No, not exactly.

The only way you can restore an individual table in SQL 7 is to have the table created in its own file group. Then you can restore the individual table.

Before you go out and do this, though, be aware that if the table to be restored is referenced in a declarative referential integrity constraint (that is, if its primary key is used as a foreign key somewhere else) then you bear the weight of fixing the integrity after the restore, because the foreign key relationships are sure to be out of whack after the restore.

The answer is don't do this; I think it's a bad practice. You'd be better off working out the timing and size requirements for complete database backups and differential logs.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date