Microsoft® SQL Server® 2012 Bible

607 Chapter 22: Maintaining the Database 22 FIGURE 22-2 Use the Toolbox to add new tasks to your maintenance plan. FIGURE 22-3 D ...

608 Part V: Enterprise Data Management Sometimes you may not want to use the Properties window. For example, you might be workin ...

609 Chapter 22: Maintaining the Database 22 You know when a task is complete by the appearance of the square in the design area. ...

610 Part V: Enterprise Data Management Select the scheduling requirements for the task. For example, you can set a task to run d ...

611 Chapter 22: Maintaining the Database 22 Choose a connection name that refl ects the server and instance. Using a name such ...

612 Part V: Enterprise Data Management FIGURE 22-8 Add new connections as needed to perform maintenance tasks. The features of t ...

613 Chapter 22: Maintaining the Database 22 Command-Line Maintenance Database maintenance is normally performed within SQL Serve ...

Summary This chapter covered database maintenance in detail. SQL Server offers a rich set of commands and utilities that you can ...

615 CHAPTER 23 Transferring Databases IN THIS CHAPTER Using the Copy Database Wizard Generating SQL Scripts Detaching and Attach ...

616 Part V: Enterprise Data Management The keys to determining the best way to move a database are knowing how much of it needs ...

617 Chapter 23: Transferring Databases 23 destination server’s SQL Server Agent is not running, the wizard will prompt you to st ...

618 Part V: Enterprise Data Management FIGURE 23-1 Select your preferred choice of transfer. FIGURE 23-2 Select the databases yo ...

619 Chapter 23: Transferring Databases 23 On the Confi gure Destination Database screen the wizard asks you to confi gure the de ...

620 Part V: Enterprise Data Management Working with SQL Script Sometimes when you want to move a database, it is important to kn ...

621 Chapter 23: Transferring Databases 23 With a focus on generating scripts with Management Studio, open the Management Studio ...

622 Part V: Enterprise Data Management The Set Scripting Options screen, as shown in Figure 23-4, contains several options for s ...

623 Chapter 23: Transferring Databases 23 If you wish to have more granular options for your generated scripts, you can click th ...

624 Part V: Enterprise Data Management FIGURE 23-6 Results of the script generation process. Detaching and Attaching Although it ...

625 Chapter 23: Transferring Databases 23 If you detach a database from a lower level of SQL Server and attach it to a higher le ...

626 Part V: Enterprise Data Management After the fi le is detached, the database disappears from the list of databases in Manage ...