Open databases from SQL Server like you do it with MySQL with PhpMyAdmin

i have a backup from a data base (SQL Server), i never worked with this type (开发者_StackOverflowalways with MySQL and PhpMyAdmin to see the data). How can i see the data who is inside the backup? there is a Microsoft program to do that? like access.

Using SQL Server Management Studio, you use Restore feature. The process is laid out in the MSDN documentation.

Obviously, you restore to another SQL Server database instance. The version of the instance can be newer than the version the backup came from - the compatibility level will just be set accordingly.

depends whether you want to pay for the solution ;) If you have the disk space and don't want to pay then you have to restore the backup.

If you dont have the disk space, and/or don't mind paying and/or you only want to restore a certain subset of the data you can use quest software's litespeed http://www.quest.com/litespeed-for-sql-server