Difference between revisions of "View MS SQL .BAK Files"
From Hostek.com Wiki
m (Briana moved page View BAK File to View MS SQL .BAK Files without leaving a redirect) |
|||
Line 3: | Line 3: | ||
*The best way to view a .bak file is to create a MSSQL database on your local system and restore the .bak file into it. Once you've done this you can view the tables in SQL Management Studio and view the database content. | *The best way to view a .bak file is to create a MSSQL database on your local system and restore the .bak file into it. Once you've done this you can view the tables in SQL Management Studio and view the database content. | ||
+ | |||
+ | '''Need to backup or restore you MSSQL Database?''' Visit our [https://wiki.hostek.com/Backup_%26_Restore_Databases_-_MS_SQL How to Backup and Restore MSSQL Databases] Page. | ||
[[Category:Databases-MSSQL]] | [[Category:Databases-MSSQL]] |
Latest revision as of 17:45, 24 February 2015
Viewing MSSQL .bak Files
- To view the contents of a .bak file you will need use a program such as SQL Management Studio. Using a text editor will not work as .bak files are not text based files and only contain raw data.
- The best way to view a .bak file is to create a MSSQL database on your local system and restore the .bak file into it. Once you've done this you can view the tables in SQL Management Studio and view the database content.
Need to backup or restore you MSSQL Database? Visit our How to Backup and Restore MSSQL Databases Page.