Copying and Moving Databases
Series Description
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.
Series Details
Total Videos: 4
Total Content Length: 00:36:19
Series Videos
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
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
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
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
