Quote:
Originally Posted by ck9663
Export them - The problem with this is, you can not backup relationships, triggers, constrains, etc. You might need to script the tables.
Or just backup the entire db. During restore, restore it to a new db and just get the data from the tables you need.
-- CK
Since i need all relationship and i have huge number of tables, I can not be able to follow your first suggession.
Only two tables are in huge size(around 100GB) in my database. So when i try to backup the database, it is geting more time. So what i need is i want to take backup except these two tables.
Thanks,
