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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-13 : 08:44:24
|
| Michael writes "I am keeping the most current 12 months worth of data in a DSS on a rolling basis. I have separate tables for each month because the type and number of fields can vary from month to month. Is there a way for me to back up and restore just one month's tables, and then restore them later if necessary? When, for example, I get the data for month 13, I would like to be able to back up the data for month 13 and drop the tables from the production database. If I need to restore the tables from backup for month 13 to the production database, I could do so. Has anyone successfully done this?Thanks,Michael" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-13 : 09:35:22
|
| You can copy the tables to another database then backup that database.Also you could keep all the tables in there own months database and access them via the 3 part name or via views in the client database.This might cause permission problems though.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-11-13 : 11:14:59
|
| Not sure if this will work or not, but I think you could store each of the tables on their own file in their own file group. Then backup and restore file groups as necessary. As I said, I think this is possible from some of the things I've read, but you would need to dig into it more to make sure it's feisable.Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
Backing up and restoring selective tables?