Fix the annoying “Suspect” issue attaching the AdventureWorks database for the 70-433 exam

HomeIT Fix the annoying “Suspect” issue attaching the AdventureWorks database for the 70-433 exam
Feb
19

Fix the annoying “Suspect” issue attaching the AdventureWorks database for the 70-433 exam

by in IT

I wasted today some time while studying for the Microsoft SQL Server 2008 Development (70-433) exam because every time I attached the AdventureWorks database to test, it was marked as “suspect” so I was unable to use it.

I found a very easy way to avoid the “Suspect” issue for adventure works.  I was a bit annoyed by it but then I decided to read the error message.

It is complaining about the file placeholder.txt being corrupted.  Simply delete that file and reattach.  Problem solved!

70-433\Databases\AdventureWorks2008\Documents

You can read one of the posts regarding this issue here:

http://social.msdn.microsoft.com/Forums/pl-PL/sqlserversamples/thread/7abfc1f6-fb74-4a41-8272-c44c34f060d3?prof=required


About the Author:

Xavier is an entrepreneur, project manager, trainer, Certified Scrum Master & Professional and Certified Microsoft professional who has spent a great deal of his career working on cutting edge projects, with a primary focus on .Net and recently iOS. His expertise is primarily web applications, search and mobile. Throughout multiple projects he has acquired skills in dealing with complex enterprise software deployments with companies that range from startups to Microsoft. Also worked as a worldwide v-trainer/evangelist for Microsoft.
«
»
Share this:   

Leave a Comment!

Your email address will not be published. Required fields are marked *