Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BACKUP DATABASE [sdusd_district] TO [sdusd_district_backup] WITH NOFORMAT, NOINIT, NAME = N'sdusd_district-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
- GO
- USE master;
- GO
- DROP DATABASE YourDB;
- GO
- RESTORE DATABASE YourDB
- FROM DISK = '/var/opt/mssql/backup/YourDB.bak'
- WITH MOVE 'YourDB' TO '/var/opt/mssql/data/YourDB.mdf',
- MOVE 'YourDB_Log' TO '/var/opt/mssql/data/YourDB_Log.ldf'
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement