The Voice of the DBA Why Is It Complicated?

MEVIOtoday

Oct 31, 2009 Why Is It Complicated?

I was answering a post the other day on backups, and I realized that it's a somewhat complicated subject. You have to know that there are multiple types of backups, and that if you want to restore a database with logs you need to do so with NORECOVERY. The logs have to be in order, there are logins to sync with users, stripes can easily, and inadvertently, be created. There are many, many options for the accidental DBA to be aware of.

Why is that so? Why can't the "restore" script be stored as part of the backup file and let the user open it, and get notified if there are issues. Or walked through the process? If you open a diff, can't it include the "name" of the last full? Or search for that file in the folder? What about logs, can't SSMS just "figure out" what LSNs are in which files and load them up automatically? Shouldn't a log have the name of the last full backup in it? Or the name of the last and next log backup files?

Read the rest of Why Is It So Complicated? at SQLServerCentral

Episode Comments

Success! Your comment will be posted when the producer approves it.

Fans of This Show also Like

Special Offers from This Show

Coupons and promo codes at MevioOffers