how to Backup only selected tables

[rsrinivasan]

Hi all,

I am using SQLSERVER 2000. I want to backup database only selected tables.
How can i do it?

Thanks in advance,

[amitpatel66]

Are you looking at taking a backup in the hard disk or in the database itself?

[rsrinivasan]

Are you looking at taking a backup in the hard disk or in the database itself?

Taking backup in hard disk only.

[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

[rsrinivasan]

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,