Skip to content

Instantly share code, notes, and snippets.

@JwanKhalaf

JwanKhalaf/command

Created January 22, 2020 16:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save JwanKhalaf/9bf20b72821e91e54e8a246671bad3ff to your computer and use it in GitHub Desktop.
Save JwanKhalaf/9bf20b72821e91e54e8a246671bad3ff to your computer and use it in GitHub Desktop.
Download ZIP
Raw
command
sqlcmd -S localhost -U SA -Q "RESTORE FileListOnly (RESTORE FILELISTONLY FROM DISK = N'/opt/mssql/BejebejeDb2018-04-13.bak'), MOVE '2J8fz00d6chl' TO '/opt/mssql/2J8fz00d6chl.mdf', MOVE '2J8fz00d6chl_Log' TO '/opt/mssql/2J8fz00d6chl_log.ldf', NOUNLOAD, REPLACE, NORECOVERY, STATS =5"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment