How can I restore DB using T-SQL?
I'm working on linux(ubuntu)
I't very easy, Just use this example:
RESTORE DATABASE <Local DB name> FROM DISK = '/<path to DB>/Downloads/BitExperts-15-8-2019.bak' WITH REPLACE, MOVE '<DB name from backup>' TO '/var/opt/mssql/data/<Local DB name>.mdf', MOVE '<DB name from backup>_log' TO '/var/opt/mssql/data/<Local DB name>.ldf' GO
FavScripts.com is a free tool to save your favorite scripts and commands, then quickly find and copy-paste your commands with just few clicks.
Boost your productivity with FavScripts.com!