Created
September 25, 2018 20:17
-
-
Save EricCote/a7a047899e9a755b1621acd16305af40 to your computer and use it in GitHub Desktop.
Sql Database Adventure Works LT 2016 Restore
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --SELECT * FROM Sys.Databases | |
| --DROP DATABASE [C:\DEMO\ADVENTUREWORKS_DATA.MDF] | |
| -- https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksLT2016.bak | |
| RESTORE DATABASE AdventureWorksLT2016 | |
| FROM DISK='C:\Users\eric\Downloads\AdventureWorksLT2016.bak' | |
| WITH | |
| MOVE 'AdventureWorksLT2012_data' TO 'C:\Data\AdventureWorksLT_data.mdf', | |
| MOVE 'AdventureWorksLT2012_log' TO 'C:\Data\AdventureWorksLT_log.mdf' | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment