how to back up certain table or files

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

how to back up certain table or files

Author

Topic

ejoeyz_85
Yak Posting Veteran

54 Posts

Posted - 2008-03-31 : 13:35:17

hello everyone... i need ur help... how can i back up only a certain table that i want using sql server management studio?? or mbe some commands...???

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-31 : 13:58:19

Use import/export wizard to copy to same database but with different name. Your indexes and constraint doesn't get copied over.You have to manually apply.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-31 : 13:59:36

Or if you have table in seperate Filegroup, You can use Filegroup Backup.

ejoeyz_85
Yak Posting Veteran

54 Posts

Posted - 2008-03-31 : 14:33:40

how can i do technically? can u show me??

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-31 : 14:38:55

Open import/Export wizard- Connect to server and database- copy certain table - Destination table- change it to like [yourTable]backup .Make sure it goes to same database and same server. Manually apply indexes and constraint from original table.
or
create new table(different name) with same structure:

Insert into newtable
select * from oldtable.

ejoeyz_85
Yak Posting Veteran

54 Posts

Posted - 2008-03-31 : 14:47:12

what if i have a trigger... for example table user, i have created a trigger for table user... after copy a certain table n then i juz want to copy a trigger file only, can i do that??

ejoeyz_85
Yak Posting Veteran

54 Posts

Posted - 2008-03-31 : 15:19:53

so anyone help me?? its really urgent...

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-31 : 15:20:19

You are asking for only backup of single table.Just put different name for it.

ejoeyz_85
Yak Posting Veteran

54 Posts

Posted - 2008-03-31 : 15:22:30

so meanz trigger file cannot copy?