Skip to content

Instantly share code, notes, and snippets.

@marvinhosea

marvinhosea/Restoring Database SQL Server

Last active December 2, 2019 15:45
Show Gist options
  • Save marvinhosea/65195c5b92a9bda7f46dcd037af3bf2e to your computer and use it in GitHub Desktop.
Save marvinhosea/65195c5b92a9bda7f46dcd037af3bf2e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Restoring Database SQL Server
RESTORE FILELISTONLY from DISK = '/var/www/erp/harias.bak'
RESTORE DATABASE NEWDB
FROM DISK = '/var/www/erp/harias.bak'
WITH MOVE 'HARIAS OUTFITTERS LIMITED' TO '/var/opt/mssql/data/HARIAS OUTFITTERS LIMITED.mdf',
MOVE 'HARIAS OUTFITTERS LIMITED_log' TO '/var/opt/mssql/data/HARIAS OUTFITTERS LIMITED_log.ldf'
//WORKING
ALTER DATABASE POSDB
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE
RESTORE DATABASE POSDB
FROM DISK = '/var/www/erp/harias.bak'
WITH MOVE 'HARIAS OUTFITTERS LIMITED' TO '/var/opt/mssql/data/POSDB.mdf',
MOVE 'HARIAS OUTFITTERS LIMITED_log' TO '/var/opt/mssql/data/POSDB_log.ldf',
REPLACE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment