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.
| Author |
Topic |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2006-03-31 : 11:09:24
|
| Guys,In my instance I have 6 database which are similar in schema. In each of these databases I have 2 tables named configuration and secrights. I want to run nightly job which backsup only these 2 tables (since these databases are huge - 20gb, I dont want to restore the backups for getting these 2 tables incase they are corrupted). Can you guys think of any easy way to do it for each of the database as part of scheduled job processAny suggestions/inputs would helpThanks |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-31 : 11:19:42
|
| U can use any of the following :-- Replication-- DTS package-- Stored Procedure to do the taskSrinika |
 |
|
|
nosepicker
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-03-31 : 12:26:21
|
| You can move those tables into a separate filegroup and then perform a backup of just that filegroup. |
|
|
|
|
|
|
Backup of tables only