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 - 2003-07-28 : 07:18:19
|
| Crow writes "I'm running SQL 7. My database has a parent table with important information, and a child table with unimportant information. Because of money (thus hardware, thus storage space) limitations, I don't want to save any transaction log entries involving the child table. I only want to be able to back up and restore the parent table and its transaction log. Is there any way to keep the transaction log for the child table in a separate area that can be truncated at will, without losing the transaction log data for the parent table?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-07-28 : 07:23:00
|
| Well, you can't log one table and not another. You can backup and restore filegroups though, so if you place the tables on separate filegroups and back up only the filegroups, you effectively get the separation you're looking for. The log will still contain transactions in both tables though.The natural question is: if the child table has unimportant information, why do you even have it in the database? |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-07-28 : 08:25:11
|
| You can put the child tables in a separate database and set that to use the simple recovery model.It means you won't be able to use referential integrity between the tables and also may have a problem with restoring a database unless the restore is done from an off-line backup.A transaction log is a logical circular file for the database so you can't segregate entries in it.==========================================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. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-07-29 : 23:16:40
|
quote:
simple recovery model
Truncate log on checkpoint. I'm not sure this is a good solution, but there really is no way to turn of logging.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
|
|
Discard transaction log entries for unimportant tables