Restore file database (.bak) SQL Server di Ubuntu. File backup database menggunakan AdventureWorks2019 Lightweight yang dapat diunduh di https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms
SQL Command:
RESTORE FILELISTONLY FROM DISK = N’/home/walim/Desktop/AdventureWorksLT2019.bak’
GO
RESTORE DATABASE AdventureWorksLT2012
FROM DISK = N’/home/walim/Desktop/AdventureWorksLT2019.bak’
WITH MOVE ‘AdventureWorksLT2012_Data’ TO ‘/var/opt/mssql/data/AdventureWorksLT2012.mdf’,
MOVE ‘AdventureWorksLT2012_Log’ TO ‘/var/opt/mssql/data/AdventureWorksLT2012_log.ldf’
GO
Comments are closed.