Simple • Straightforward

So easy a Caveman
Programmer can do it.

›› Let's Get Started

Backups and Transaction Logs

Simple or Complicated?

The concept of backing up data is simple enough, and we are only going to touch on the main backup type. Of course there are different ways to set your configuration files, but we want to keep this easy to understand



Backups

Take a full backup at least once a day. When you are thinking of your storage requirements and database size, remember to consider how many backups you will need to store. In databases that are used frequently during the day, I would recommend keeping 3-4 days worth of full backups. Some people might want several months worth, others probably don't care. Consider this type of scenario when you think of your backup needs:

- You walk into the office on Monday morning and find out something bad happened to your application on Saturday morning. A few days worth of can help you recover from at least Friday night.



Transaction Logs

What you might also be thinking is how to recover to a specific point in timeā€¦ between the backup cycles. This is when your transaction log backups come in handy. There is no need to take a full backup every hour. Just setup your transaction logs to get backed up once an hour to save on TONS of space.

If you want to get into the details of backups, I would suggest hoping over to Microsoft's website and taking a look. Link below:

http://msdn.microsoft.com/en-us/library/ms187048.aspx





Comments

Name:
Title:   
Commenting Currently Disabled


Lucky
8/4/2011 7:38:06 PM



Hey, you're the goto exeprt. Thanks for hanging out here.
Many apperceive the cast Tag Heuer, which has replica watches uk some arising collectible examples. The added abnormal and colorful, the added absorption they get. This includes the Monaco model, although these models accept rolex replica already acquired abundant cachet to be on the top ancillary in agreement of amount if they accept accustomed able affliction and storage. Other brands with abeyant for beginning collectors are Ulysee-Nardin, Universal Geneve and Longines if in excellent condition, all of replica rolex which are featured in Haines book Vintage Wristwatches.