April 4, 2008 at 12:31 pm
I am a newbie (and, of course, a wannabie):)
I looked at the SqlServer05 Developer wizzard.
How do I select (equally important...not include)
certain tables when creating a backup_file.bak?
Basically, I want make backup files for two groups of tables.
1. special high security tables
2. all other tables
If I cannot do it from the
1. wizzard
2. then from a custom stored procedure? (how?)
3. then from some cleaver third party software? (and which one?)
In the near future, I will want to perform such a backup task on a standard version of SqlServer 2005.
Grateful for any help!
April 4, 2008 at 12:56 pm
Sql Server doesn't have table backup though there are ways you can do this..
1. Create important tables or the tables you want to backup in one filegroup and then take filegroup backup.
2. You can bcp out the table to text file and later bcp in if needed.
3. create new table with different name on same server or another server and copy the data from orig table to this table.
4. Use third party tools like litespeed or sqlsafe that allows table backup.
There could be more ways to do it, someone in the group will let you know.
NJ
April 4, 2008 at 1:18 pm
Terrific, thanks for the advice.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply