Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Backup and Recovery > Moving Databases to Different Servers

Moving Databases to Different Servers

Sometimes you want to have the same database on more than one server. Perhaps you want to take a copy of a production server to create a test database, or move a database to a client site. In addition, you may need to maintain a warm standby server. You can do this in several ways:

  • Using BACKUP and RESTORE

  • Using Data Transformation Services (DTS)

  • Using sp_detach_db and sp_attach_db


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint