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 |
|
puneeth.shreya
Starting Member
1 Post |
 Posted - 2010-05-12 : 08:27:55
|
| Consider there is 100000 to 200000 records being inserting into table for each 2 second. I need to backup the records which is being inserted.how will u do that. Please let me know the answer |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-12 : 10:13:49
|
| That's 8,640,000,000 records inserted a day. You've got better hardware than I have!How do you want to back them up? 1) Total database copy to a file? (Use the BACKUP command)2) To keep an Audit trail of changes made? (Use a TRIGGER to save the original value of the record to a separate "audit" table) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
backup in sqlserver 2005