January 17, 2011This neat little snippet shows you alot of information from a SQL database backup (.bak file)
FROM DISK = N'c:\temp\dbMyDatabase.bak'
If this doesn't work you're probebly trying to run it on an older SQL Server version than the backup was taken from.
Unfortunately I haven't found a proper lookup table to translate the version number to SQL Server version, but here's two:
611 = SQL Server 2005
655 = SQL Server 2008
If you find a good resource for version lookup, please post it in the comments, thanks!