Can Toad for SQL Server connect to and read a .bak file? Or help create either a odbc or ole db connection to a .bak file?
Hi,
Toad for SQL Server can use a .bak file to restore a database.
We can right click the database in Object Explorer then select restore database like below.
In the Restore Database Window, can select a .bak file.
Toad cannot read a .bak file to see objects or data directly.
It cannot create a obdc or ole connection to a .bak file neither.
Toad can export data from database.