Also some labels would do a deal where if you buy an album through the usual retailers, the label takes a cut. But, they sell the albums to the artist at cost, and they can then sell them for full profit. So if you buy a CD through the artist’s web site, they make a lot more than if you buy it through a retailer.
If it’s Microsoft SQL you should be able to replay the transaction log. But you should be doing something like daily full backups and hourly incremental or differential backups to avoid this situation in the first place.
Also some labels would do a deal where if you buy an album through the usual retailers, the label takes a cut. But, they sell the albums to the artist at cost, and they can then sell them for full profit. So if you buy a CD through the artist’s web site, they make a lot more than if you buy it through a retailer.