DBeaver: Restore File Database MS SQL Server (.bak) ke Localhost di Ubuntu Linux

SQL — 23/10/2022 · 9 Comments



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

9 Comments

  9. Thanks you so much bro!
    I had a .bak file in the ubuntu. I didn't find anywhere that how can import .bak file to DBeaver.
    But, I succeed thanks to you! 🙂

Leave a Reply

© 2023 53GB