APPENDIX n SQL SERVER 2008 CONSIDERATIONS 325
A WISH LIST
Unfortunately, SQL Server 2008 still retains a number of misleading features. I would like to think that
by the time SQL Server 2008 is finally released, some of these annoying features will be changed:
??? Default recovery after a restore: It is still far too easy to recover the database in the midst of a
restore process. If left unspecified, the default action for a RESTORE DATABASE or RESTORE LOG
command is WITH RECOVERY.
??? Misleading Backup and Restore screens in the GUI: SQL Server 2008 uses the same GUI tool
design for the Backup and Restore screens. The Backup screen still has that same Backup Location
list box, which can give the impression that selecting a file in that list box means that the
backup will be stored in that file. In reality, having multiple files in the Backup Location list box
means that the backup will be striped across all files.
Both of these examples seem simple enough to change, but perhaps I shouldn??™t complain. At least
what I??™ve said in Chapters 2 and 3 still applies to SQL 2008.
Pages:
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610