Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. BACKUP DATABASE [sdusd_district] TO [sdusd_district_backup] WITH NOFORMAT, NOINIT, NAME = N'sdusd_district-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
  2. GO
  3.  
  4. USE master;
  5. GO
  6. DROP DATABASE YourDB;
  7. GO
  8.  
  9. RESTORE DATABASE YourDB
  10. FROM DISK = '/var/opt/mssql/backup/YourDB.bak'
  11. WITH MOVE 'YourDB' TO '/var/opt/mssql/data/YourDB.mdf',
  12. MOVE 'YourDB_Log' TO '/var/opt/mssql/data/YourDB_Log.ldf'
  13. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement