i have a backup from a data base (SQL Server), i never worked with this type (always 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.
A:
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.
OMG Ponies
2010-07-08 18:57:37
If you're trying to do this on your local computer instead of another server, download MS SQL Server Express and you'll get the Management Studio and a local SQL Server. http://www.microsoft.com/express/database/
iKnowKungFoo
2010-07-08 19:04:10
FYI: a "database instance" can contain multiple databases...
OMG Ponies
2010-07-08 19:06:02
A:
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
Blootac
2010-07-21 07:53:26