Microsoft® SQL Server® 2012 Bible

627 Chapter 23: Transferring Databases 23 If you want to reattach a database with code, the counterpart to sp_detach_db is the s ...

628 Part V: Enterprise Data Management and from any data source for which a managed .NET Framework data provider or a native OLE ...

629 Chapter 23: Transferring Databases 23 exists, it enables you to either delete or append rows to the destination table. If no ...

630 Part V: Enterprise Data Management FIGURE 23-10 Indicating to run the package immediately and saving the package with encryp ...

631 Chapter 23: Transferring Databases 23 To begin creating and deploying DACs, you must fi rst register a database as a DAC and ...

632 Part V: Enterprise Data Management Now that your application is encapsulated in a DAC package, you need to deploy it. Connec ...

633 Chapter 23: Transferring Databases 23 ■ (^) The Copy Database Wizard is useful for copying or moving one or more databases f ...

c23.indd 634c23.indd 634 7/31/2012 9:25:23 AM7/31/2012 9:25:23 AM http://www.it-ebooks.info ...

635 CHAPTER 24 Database Snapshots IN THIS CHAPTER Understanding How Database Snapshots Work Creating, Querying, and Dropping a D ...

636 Part V: Enterprise Data Management ■ (^) You can create database snapshots only on the same SQL Server instance where the so ...

637 Chapter 24: Database Snapshots 24 A database snapshot is not the same as the source database. It is a different database and ...

638 Part V: Enterprise Data Management read-only database. After you create a snapshot, it can be queried the same way as regula ...

639 Chapter 24: Database Snapshots 24 For each data file in the source database, a data file in the database snapshot exists. Th ...

640 Part V: Enterprise Data Management After you create the database snapshot, you can view it using Management Studio. Using Ob ...

641 Chapter 24: Database Snapshots 24 FIGURE 24-4 Viewing the size of the database snapshot data fi le. Querying Your Database S ...

642 Part V: Enterprise Data Management When a user reads from the database snapshot, SQL Server accesses the in-memory bitmap an ...

643 Chapter 24: Database Snapshots 24 Dropping a Database Snapshot Dropping a database snapshot is similar to dropping a regular ...

644 Part V: Enterprise Data Management As per the error message, you must drop all the database snapshots except the one that yo ...

645 Chapter 24: Database Snapshots 24 Any data stored outside the application will not be rolled back when the database snapshot ...

c24.indd 646c24.indd 646 7/31/2012 9:25:50 AM7/31/2012 9:25:50 AM http://www.it-ebooks.info ...