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 |
|
jtubaugh
Starting Member
1 Post |
 Posted - 2006-02-03 : 02:41:50
|
| I have a question I sure hope someone can answer.2-node SQL 2000 cluster, single instance (default)Example....Batch process containing 100,000 records begins and before it completes the server crashes.I understand non-committed transactions are rolled-back and committed transactions are rolled-forward.Does anyone know if there is a way to script the process of starting the batch process again? How about doing a compare and only doing those that were not committed? This would be very beneficial so manual intervention is not needed.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-03 : 13:27:57
|
| Import the data into a staging table. Do a compare between the staging table and your actual table to determine what rows need to be imported still.Tara Kizeraka tduggan |
 |
|
|
|
|
|
non-committed transactions + failover + clustering