Dừng một thể hiện SSE 16. Bây giờ cố gắng để thực hiện truy vấn trong cửa sổ SQL chỉnh sửa (hoặc cố gắng bất cứ điều gì để truy cập vào các ví dụ, nếu bạn đã đóng cửa sổ). Sẽ không có kết quả từ cửa sổ, và cửa sổ tin nhắn sẽ thông báo lỗi, như trong hình 2-16. | CHAPTER 2 GETTING TO KNOW OUR TOOLS 27 Figure 2-14. A database diagram Figure 2-15. Stopping an SSE instance 16. Now try to execute the query in the SQL edit window or try anything to access the instance if you ve already shut the window . There will be no Results window and the Messages window will report an error as in Figure 2-16. 28 CHAPTER 2 GETTING TO KNOW OUR TOOLS Figure 2-16. Error on trying to query a stopped SSE instance 17. To start SQLEXPRESS right-click the instance node in Object Explorer click Start and click Yes in the confirmation message box. Click the Northwind node and retry the query. It should work fine. 18. To restore the Northwind database right-click the Northwind node in Object Explorer than click Tasks Restore Database. . You ll see the window in Figure 2-17. 19. Click OK and you ll get the message box in Figure 2-18. You can t restore the Northwind database because the kind of restore you re doing requires exclusive access and SSMSE is currently connected to Northwind through the query. Click OK to close the message box then close the SQL edit window click No when prompted to save it . 20. Click OK again in the Restore Database window. You should get the message box shown in Figure 2-19. To see that the database has been restored try to expand the Database Diagrams node under Northwind. You saved a diagram earlier but once again the plus sign disappears since the database diagram was stored in Northwind in step 14 but you backed up the database in steps 7 and 8 so you ve restored Northwind to a state before the diagram was saved. The same holds true for any data in any SSE database. CHAPTER 2 GETTING TO KNOW OUR TOOLS 29 Figure 2-17. Restoring the Northwind database Figure 2-18. Restore-failure message box Figure 2-19. Message box stating the Northwind database is .
