• Just to append for future readers:

    A backup of a drive where the .ldf, .mdf, or .ndf files live is not a SQL Server backup. From my experience, if the backup was taken while the database was ONLINE and the services were running, the file will be unreadable and unusable for emergencies like this one. So, even if you had data files and log files from the same time, it's doubtful your D: drive backup would have worked out for you.

    The only way such file backups are ever usable (again, in my experience) is if they were taken when the database was OFFLINE or the sql services had been stopped. And even then, this is a really bad backup option.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.