Copying and Moving Databases

Learn about what makes SQL Server databases harder to move than normal file system files, and see hands-on examples of exactly what you'll need to do to either easily create copies of your databases or to move them around from one server to the other.

Total Videos: 4

Total Content Length: 00:36:19

 

Options for Copying and Moving Databases

Learn about technical considerations for moving and copying SQL Server databases, and learn about the videos and options available for copying and moving your own databases.

Covers: Database Management, File System and the SQL Server Storage Engine, Logins, Users and Roles and their impacts on copying and moving databases.

Skill Level: 000 - Overview

Video Length: 05:45

Release Date: 2008-10-20

Attaching and Detaching SQL Server Databases

Learn the exact steps you'll need to take to successfully detach and attach SQL Server 2005 and 2008 databases in order to move or copy them.

Covers: SQL Server Management Studio, the SQL Server File System, and Database Management options required to attach and detach SQL Server 2005/2008 databases.

Skill Level: 100 - Beginner

Video Length: 10:33

Release Date: 2008-10-29

Copying and Moving SQL Server Databases

Learn how to easily copy and move your SQL Server 2005 and 2008 databases using backups - which is much easier than you might think.

Covers: Database Management, SQL Server Management Studio, File System operations, and Administrative Tasks.

Skill Level: 100 - Beginner

Video Length: 10:05

Release Date: 2008-10-30

Copying and Moving SQL Server Logins

Learn how to transfer and re-map SQL Server Logins from one server to another, and see how to enumerate and troubleshoot logins against assigned users and roles within SQL Server databases.

Covers: Database Management, Logins, Security, Roles and Users.

Skill Level: 200 - Intermediate

Video Length: 09:56

Release Date: 2008-10-30