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 - 2006-08-07 : 13:58:36
|
| Ahmad writes "Hi & Hello to every one ,1: I want to know possible best solution for moveing all backup tables. Senerio look like , we have a fast data growing table named 'em_demographics'.Whenever a record is old according to business logic it is moved to a backup table in same database mplementing through trigger).Now there are more than 20 backup tables.which are just increasing the size of database primary file which is a problem in downloading or restoring.So i decide to move these table to reduce the size of primary file.which consideration should be milestone.so that i donot face any problem in my backup startegy.Can any one has done same as before.wheater i move these tables to othere database or include a filegroup in same database and move all such tables on this filegroup.2: I have a table have space used more than 5gb.What are possiblities to make its effienct and fast sacaning.should i apply horizantal partition ?I want also to reduce pages consumed by this table data.(But remember insertion rate always high)i hope, i explain it precisly.Thnxs in advance " |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-08-07 : 22:09:28
|
| We export them to "native" format BCP files daily, and delete them. We keep the BCP files "indefinitely", so if we every need to check the data we can re-import the BCP files.Kristen |
 |
|
|
|
|
|
Automatically move all user datab backup tables