Conclusion


To transfer your database from one server to another, you can back it up and restore it on the target server, you can copy it while it is detached, and then attach the copy to the target server, you can use SQL Server's replication features, or you can use SSIS. Which method you choose depends on your application and your environment. You'll find the most versatility through a combination of SQL Server Agent and SSIS.

Chapter 4 Quick Reference

To

Do this

Create a database backup in SQL Server Management Studio

Right-click the database in Object Explorer, and select Tasks | Back Up.

Restore a database in SQL Server Management Studio

Right-click the Databases folder in Object Explorer, and select Restore Database.

Detach a database in SQL Server Management Studio

Right-click the database in Object Explorer, and select Tasks | Detach.

Attach a database in SQL Server Management Studio

Right-click the database in Object Explorer, and select Tasks | Attach.

Configure Peer-to-Peer Replication in SQL Server Management Studio

Right-click the Replication node in Object Explorer and select Configure Distribution from the context menu to run the Configure Distribution Wizard. Run this wizard on both servers in the replication group.

Set up an SSIS project

Open SQL Server Business Intelligence Development Studio (BIDS). Select File | New | Project, then select the Business Intelligence Projects node in the Project Types list and the Integration Services Project template from the Templates list. Add and configure connection managers, a data source, and a data destination.

Schedule a backup using SQL Server Agent

In SQL Server Management Studio, open the SQL Server Agent node in Object Explorer. Right-click the Jobs folder and select New Job from the context menu.





Solid Quality Learning - Microsoft SQL Server 2005. Applied Techniques Step by Step
Microsoft SQL Server 2005: Applied Techniques Step by Step (Pro-Step by Step Developer)
ISBN: 0735623163
EAN: 2147483647
Year: 2006
Pages: 115

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net