Toad World® Forums

Reading a .bak file

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.