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 |
|
manared
Starting Member
10 Posts |
 Posted - 2007-02-13 : 14:25:27
|
| I have a database that has a table with tons of data in it and it is getting close to the 999 days before it starts deleting the oldest records. Is there a way to allow the table to keep all of the information? I don't think there is, so here is my next question. Is there a way that I can move the entire table into another database to save all the information and start over with the 999 days? My main goal here is to not lose ANY information from any table from the database. Also, I was thinking that when an entry is added into the main table, if it can also be added into the other table where I move the old data? I think a trigger can be used here, but I'm not sure how to do one in 2005. Thank you very much in advance for your help!!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-13 : 14:32:54
|
| Why would data be deleted after 999 days? There is nothing in SQL Server that would delete the data.Tara Kizer |
 |
|
|
|
|
|
backup of database - don't lose info - triggers?