Skip to content

Instantly share code, notes, and snippets.

@raphaeldealmeida

raphaeldealmeida/import.log

Created February 13, 2019 09:03
Show Gist options
  • Save raphaeldealmeida/916e764867568eebf96292adf7ea399d to your computer and use it in GitHub Desktop.
Save raphaeldealmeida/916e764867568eebf96292adf7ea399d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
import.log
1 ls /home/backup/Onboard.bak
2 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [onboard] FROM DISK = N'/home/backup/Onboard.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATUS = 5"
3 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [onboard] FROM DISK = N'/home/backup/Onboard.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5"
4 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [onboard] FROM DISK = N'/home/backup/Onboard.bak' WITH FILE = 1, NOUNLOAD, REPLACE, NORECOVERY, STATS = 5"
5 ls /home/backup/Onboard.bak
6 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [central] FROM DISK = N'/home/backup/Central.bak' WITH FILE = 1, NOUNLOAD, REPLACE, NORECOVERY, STATS = 5"
7 /opt/mssql-tools/bin/sqlcmd
8 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA
9 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [onboard] FROM DISK = N'/home/backup/Onboard.bak' WITH FILE = 1, NOUNLOAD, REPLACE, NORECOVERY, STATS = 5"
10 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA
11 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [onboard] FROM DISK = N'/home/backup/Onboard.bak' WITH FILE = 1, NOUNLOAD, REPLACE, NORECOVERY, STATS = 5"
12 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [onboard] FROM DISK = N'/home/backup/Onboard.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5"
13 exit
14 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [onboard] FROM DISK = N'/home/backup/Onboard.bak' WITH FILE = 1, NOUNLOAD, REPLACE, NORECOVERY, STATS = 5"
15 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [central] FROM DISK = N'/home/backup/Central.bak' WITH FILE = 1, NOUNLOAD, REPLACE, NORECOVERY, STATS = 5"
16 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE FILELISTONLY FROM DISK = '/home/backup/Central.bak'"
17 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [central] FROM DISK = '/home/backup/Central.bak' WITH FILE = 1, NOUNLOAD, REPLACE, NORECOVERY, STATS = 5"
18 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA
19 eixt
20 exit
21 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE central FROM DISK = '/home/backup/Central.bak' WITH MOVE 'central' TO '/var/opt/mssql/data/central.mdf', MOVE 'central_log' TO '/var/opt/mssql/data/central.ldf'"
22 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE onboard FROM DISK = '/home/backup/Onboard.bak' WITH MOVE 'onboard' TO '/var/opt/mssql/data/onboard.mdf', MOVE 'conboard_log' TO '/var/opt/mssql/data/onboard.ldf'"
23 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE onboard FROM DISK = '/home/backup/Onboard.bak' WITH MOVE 'onboard' TO '/var/opt/mssql/data/onboard.mdf', MOVE 'onboard_log' TO '/var/opt/mssql/data/onboard.ldf'"
24 sa
25 exit
26 history
27 history > import.log
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment