Backup Restore Database Mssql ERA/ESMC Windows

You are here:
  • KB Home
  • ESET
  • Backup Restore Database Mssql ERA/ESMC Windows

Ms SQL

Open PowerShell run as administrator dan jalankan perintah berikut :

Perintah Backup :

SQLCMD -S localhost\ERASQL -q “BACKUP DATABASE ERA_DB TO DISK = ‘C:\ESET\ddmmyy.bak'”

Perintah Restore :

SQLCMD -S localhost\ERASQL -q “RESTORE DATABASE ERA_DB FROM DISK = ‘C:\ESET\ddmmyy.bak'”