Moving User Databases in SQL Server

Home/Administration, SQL Server/Moving User Databases in SQL Server

Moving User Databases in SQL Server

$15.00 $4.00

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

Categories: ,

Description

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

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.