January 3, 2007 at 2:37 pm
Has anyone seen a book that explains enough about backup plans and procedures for SQL 2000 that don't require me to be a SQL guru to understand them?
Most of the reading I have done requires an understanding of MS SQL server command line scripting, Full and Simple Recovery modes, transaction log backups and restores, and database maintenance plans.
I don't mind reading, but don't want to spend several hundred dollars on books (and spend several months reading them) just to amass a pile of knowedge on a topic that isn't relevant to my usual duties. I'd like to learn enough to protect my clients' database without knowing how to program.
Most of my clients use Symantec BackupExec. Is it as easy to restore database using this product as they claim? Their Tech Doc # 262171 would have you believe that restoring a SQL database is a quick 10 step process as easy as restoring a Word document. I have a hard time believing that.
I hope I'm not asking someone to write a 10 minute reply that will make me an instant SQL master. I would appreciate it if someone could point me to a reference written for SQL newbies that will help with this.
Any ideas?
January 3, 2007 at 3:49 pm
I really like the "Inside SQL Server" books. they do a great job of explaining the native SQL backups and I beleive it also covers maintenance plans. It's a great buy and it's only 1 book. then you will also have an excellent reference to go back to should you find yourself needing answers on other SQL topics. 1 chapter should get you up to speed to protect your client.
January 3, 2007 at 5:37 pm
SQL Server 2000 Backup and Recovery Osborne Press by Desai 213027-x is thier product number.
Cheers,
Wes
January 3, 2007 at 8:33 pm
Thanks to you both...
The "Backup and Recovery" book seems to place less emphasis on SQL Server database management and more on data protection, which is exactly what I'm looking for.
The "Inside SQL Server" book is the opposite - an apparently excellent SQL Server reference, but it deals only lightly with the topic of backup (the author actually says this in the introduction), referring to other publications for more detail on backup and restore. It gets much better reviews from previous purchasers, but the main complaints about the other book are that it deals too much with data protection planning, which is of course what I'm concerned with.
I'll order the "Backup and Recovery" book immediately.
Thanks for both recommendations - the time I spent looking into these books (using Amazon.com to look inside) has already taught me a lot about SQL Server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply