Here is another popular lab from Hands-On-Lab library: Moving User Databases in SQL Server.
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
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.
Happy Learning – The Practical Way.