O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Restoring a Database to a New Location

The database backup option is fairly straightforward. You make a backup of the database, which writes the backup to a file or set of files. The backup is restored, and any changes to the location of the database files are made at that time. Backup and restoration are discussed in detail in Chapter 11.

You can easily detach a database by right-clicking the database in the Object Explorer and choosing Tasks and then Detach. When the database is detached, you can move the file(s) to the desired location. You can then right-click the database’s node and select Attach. The Attach Databases screen that appears allows you to select the .mdf file and change the file location for any of the related database files. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required