I am about learning sitemap and roles in sitemap so I started the chapter 23 of asp.net unleashed but when I want to open a page which is related to the database it gives me the following error:
file Chapter 23\CS\SiteMaps\App_Data\aspnetdb.mdf&#39; appears to have been truncated by the operating system. Expected size is 10240 KB but actual size is 6528 KB.
Could not open new database &#39;D:\J\BOOK\SAMS\ASP.NET4\0672331128_CODE\CHAPTER 23\CS\SITEMAPS\APP_DATA\ASPNETDB.MDF&#39;. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file D:\j\book\SAMS\asp.net4\0672331128_code\Chapter 23\CS\SiteMaps\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
more intrestingly when I attached the database manually it do not allow me .is the database corrupted or should I change any thing in sql server?
View Complete Post