Moving databases may be part of scheduled maintenance, hardware failure, and planned relocation. In this lab, you will be learning different ways to copy/move a user database. This lab is divided into four exercises. In the first exercise how to attach and detach user database. In the second exercise we will learn how to take backups of user database and restore them. In third exercise we will learn about copy database wizard. In fourth exercise we will learn about scripting wizard.
Exercise 1: Detach-Attach user database
Exercise 2: Backup and restore user database
Exercise 3: Copy Database wizard
Exercise 4: Scripting Wizard