Yes, I should have taken greater care in
what I was doing, but as a fail-safe, I could have used a database snapshot as a response
technique to my own carelessness.
What I would have done (and now do religiously) if I had SQL Server 2005 is create a
database snapshot just before doing any work on the intermediary database, then perform
my task, then remove the snapshot if the process was successful. In that particular
situation, after the truncate operation completed, I could have simply snapped back to
the database snapshot I created prior to making the mistake.
???No Electromagnets in the Data Center, Please???
(Media Disaster)
A true media disaster, such as having hard disks or tapes physically damaged, is becoming
a rare occurrence these days. In general, true hardware failures such as a server failing
completely, are becoming more and more rare as technology improves. However, since a
hard drive or a tape drive is magnetic storage, it??™s susceptible to damage from anything
that generates an electromagnetic field (something even the human body does, to a very
minor degree).
Pages:
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538