1 / 25

Introduction about MS SQL Server 2005

Introduction about MS SQL Server 2005. Introduction about MS SQL Server 2005. What’s new ? Installation Connect to Database Engine Create Database Backup and restore Database Create user and grant permission for user. References. What’s new ?.

jasmine-kaufman
Download Presentation

Introduction about MS SQL Server 2005

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction about MS SQL Server 2005 BSG Group - Dau Anh Trong

  2. Introduction about MS SQL Server 2005 • What’s new ? • Installation • Connect to Database Engine • Create Database • Backup and restore Database • Create user and grant permission for user. • References BSG Group - Dau Anh Trong

  3. What’s new ? • SQL Server Management Studio : providing one integrated management console to monitor and manage the SQL Server relational database as well as SQL Server 2005’s services • Replication • Scalability • Query Notification • Service Broker • Business Intelligence : make better decisions faster • More and detail at References BSG Group - Dau Anh Trong

  4. Installation BSG Group - Dau Anh Trong

  5. Installation First, installing MS SQL Server Update Advisor. Click “Next” and “Finish” to complete install process. BSG Group - Dau Anh Trong

  6. Installation Second, installing MS SQL Server 2005 and its components. Select all component (Recommended) BSG Group - Dau Anh Trong

  7. Installation Select “Default instance” and click Next BSG Group - Dau Anh Trong

  8. Installation • Select “Use the build-in System account” and choose “Local System” in the drop down list. • We must select SQL Server Agent (very important) BSG Group - Dau Anh Trong

  9. Installation Select “Mixed Mode” option so that we can connect to DataBaseEngine through Windows accounts and SQL Accounts BSG Group - Dau Anh Trong

  10. Installation Let everything is default. BSG Group - Dau Anh Trong

  11. Installation Impossible to change options BSG Group - Dau Anh Trong

  12. Installation Don’t check any options unless you want to waste time BSG Group - Dau Anh Trong

  13. Installation Installation process, you can take a coffee or go to sleep. Because it’s very long and slow. After all, click “Finish” to complete installation BSG Group - Dau Anh Trong

  14. Connect to Database Engine • Click on “Connect” button on the top left and choose “Database Engine …” • “Server name” is “.” for localhost • Authentication type is SQL Server Authentication”. • Fill “Login” and “Password”. “Login” should be “sa” (SQL top-level user) • Don’t forget check “Remember password”, and then click on “Connect” BSG Group - Dau Anh Trong

  15. Create Database Right click on “Databases” nodes and choose “New Database …”. Then fill database name and click OK. BSG Group - Dau Anh Trong

  16. Backup Database Backup : right click on Database name. Choose Tasks Backup. Click on “Add” button to browse to backup file. BSG Group - Dau Anh Trong

  17. Backup Database Browse and name database file (extension is “.bak” for recommend). Then click “OK” to come back to “Back Up Database” dialog, click “OK” again to complete backup database. BSG Group - Dau Anh Trong

  18. Restore Database Right click on Database name, choose “Task”  “Restore”  “Database…”. Select “From device” option and browse to backup file. BSG Group - Dau Anh Trong

  19. Restore Database Choose your backup file by clicking “Add” button and click “OK” button. BSG Group - Dau Anh Trong

  20. Restore Database Check on your selected backup file. And then change to “Options” tab. BSG Group - Dau Anh Trong

  21. Restore Database Check “Overwrite existing database”. Pay attention to “Original File Name”, it should point to “C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA” folder. Then click “OK” to complete. BSG Group - Dau Anh Trong

  22. Create user Fill username and password. Select user type is “SQL Server authentication”. Uncheck “Enforce password policy” and choose “Default database” for the user (optional) BSG Group - Dau Anh Trong

  23. Grant permission for user Select “Security” node  “Login” node and double click on the username. In “Login Properties” dialog, select “User Mapping”, check on Database name and check on “db_owner” option. Then click “OK”. Now the user can access the database and manipulate on it. BSG Group - Dau Anh Trong

  24. References • http://msdn.microsoft.com/en-us/library/bb418498.aspx • http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx • http://msdn.microsoft.com/en-us/library/ms170363.aspx BSG Group - Dau Anh Trong

  25. Thanks your attention BSG Group BSG Group - Dau Anh Trong

More Related