tailieunhanh - SQL Server DBA Training

SQL Server was originally the Microsoft rebadged version of the Sybase relational database. It is only available on Windows platforms. Current version (July 2010) is SQL Server 2008 R2. The two principal differences between SQL Server/Sybase and Oracle are: 1. SQL Server has no undo or rollback segments and therefore no rollback/commit functionality, or read consistent data views; other than what little can be accommodated from the on line redo logs. 2. SQL Server architecture is: 1 host machine to 1 or more Instances to many Databases. There is no such thing as a tablespace within SQL Server. On line redo logs exist. | SQL Server DBA Training Andrew Fraser September 2010 http This course is a reduced version of Microsoft s 5 day System Administration for Microsoft SQL Server course. It focuses on the differences between SQL Server and Oracle and on the main SQL Server tasks a DBA team is likely to have to perform Installs Service Access Requests Cloning Backups Restores Datafile maintenance. DBA tasks which are out of scope for this course are upgrades and performance tuning. These notes apply to version SQL Server 2008 Release 2. Table of Contents 1. SQL Server 2. Installing and Configuring SQL 3. 4. Managing Database 5. 6. 7. Automating Administrative Tasks with Jobs and 8. Transferring Data with 9. Monitoring Tools . 20 10. Maintenance 11. 12. High Appendix A - List of Differences between SQL Server and Appendix B - Installation With SQL Server DBA Training 1. SQL Server Overview SQL Server was originally the Microsoft rebadged version of the Sybase relational database. It is only available on Windows platforms. Current version July 2010 is SQL Server 2008 R2. The two principal differences between SQL Server Sybase and Oracle are 1. SQL Server has no undo or rollback segments and therefore no rollback commit functionality or read consistent data views other than what little can be accommodated from the on line redo logs. 2. SQL Server architecture is 1 host machine to 1 or more Instances to many Databases. There is no such thing as a tablespace within SQL Server. On line redo logs exist at database level. A more complete list of differences is given in Appendix B. SQL Server does not offer an equivalent to RAC. There are SQL Server equivalents to dataguard and replication and SQL Server does offer database mirroring and failover clustering. Note that SQL commands are not executed by or as in oracle but with go. SQL