var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Attaching an MDF withou LDF
So im attempting to fix a screw up from a client.
long story short
server died, old IT guy ....long gone
Recovered the MDF and LDF but.....
i get the "log scan number passed to log scan in database is not valid."
So i attach an old Backup, turn off sql service and copy over the MDF and LDF files.
Then i get the DB attached but stuck in suspect mode.
Then put the database in Emergency mode using this command.
1.ALTER DATABASE dbname SET EMERGENCY
The next step was to run DBCC CHECKDB against that database.
1.DBCC CHECKDB (dbname) WITH ALL_ERRORMSGS
Cannot open database 'dbname' version 655. Upgrade the database to the latest version.
Im sure im using the same sql version as they were as their old sql errorlog from the recovered server shows 10.50.1600.1
and im using sql2008 r2 express
which im sure is 10.50.1600.1
How can i get this db restored, not to concerned with minor dataloss at this point