From the course: Microsoft SQL Server 2016: Installation and Administration
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Moving database files - SQL Server Tutorial
From the course: Microsoft SQL Server 2016: Installation and Administration
Moving database files
- [Instructor] Sometimes it is necessary to move the files that make up your database. Careful consideration of how to move these files is critical to ensure that you retain the data and the operation of the database after the move. There's a couple of considerations. We can move user data databases or we can move system databases. Obviously, moving the user databases is a little simpler, because it doesn't mess with the SQL Server system databases and their locations. Some of the reasons you might have for moving your database files, perhaps might be a failure recovery, so we might have had a server failure or a hard drive failure, and we need to move to a new server. You might have to do a system or database relocation for other reasons, such as the hard disk filling up. Or, perhaps you're going to run scheduled maintenance on a system and you don't want the database to be taken down, so you can move your database to another server. The types of objects we can move are the data, and…