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 |
|
markos
Starting Member
13 Posts |
 Posted - 2004-07-27 : 12:11:03
|
| I have 13 identical databases on 13 SQL servers over the network. Average db size is about 8 Gb. Now, the majority of data goes to one table and it's indexes (let's say more then 7 Gb), which I really don't need to save. So my first question would be (there are more to come:-) ) is it possible to backup the database WITHOUT that big table? I've tried to do it but the best thing I've came up wioth (don't laugh, please) is to do a DTS package that copies all the other tables from server x to server x+1 (in round robin). Tnx in advance! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-27 : 13:01:52
|
| You could use filegroups.Tara |
 |
|
|
|
|
|
Backup question