Personal Site Starter Kit

Re: How to re-create Personal.mdf

caruncool — Mon, 22 Jun 2009 05:31:56 GMT

Hi ,

But .. can you please explain it a bit further ..Bcoz after deleting the personal.mdf file i receive this error message ..

An attempt to attach an auto-named database for file C:\Documents and Settings\Bharath Kumar\My Documents\Visual Studio 2008\WebSites\PersonalWebSite4\App_Data\Personal.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Regards ,

Arun C

Re: How to re-create Personal.mdf

caruncool — Mon, 22 Jun 2009 05:13:55 GMT

Hi ,

That s fine ...But can you please suggest something on this error .. please

An attempt to attach an auto-named database for file C:\Documents and Settings\Bharath Kumar\My Documents\Visual Studio 2008\WebSites\PersonalWebSite4\App_Data\Personal.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Regards ,

Arun C

Re: How to re-create Personal.mdf

TGirgenti — Sun, 03 May 2009 10:20:41 GMT

Hello,

I'm sorry. I missed that part of this thread. I did download it and it did work.

Thanks for your help.

Tony

Re: How to re-create Personal.mdf

RaeKC — Fri, 01 May 2009 23:38:46 GMT

Hi:

"Jeremyh" did post an updated file at another thread!

And it does work. I checked it out some weeks ago and all worked fine.

Go to the link here:

http://forums.asp.net/t/1359898.aspx

He posted a link where you can download the new personal mdf. for 2008.

Rachel

Re: How to re-create Personal.mdf

TGirgenti — Fri, 01 May 2009 18:46:14 GMT

Hello.

I really appreciate you doing this, however for me it is not as easy as you make it sound. You say in your post it is 5 minutes work, yet it took me a half hour just to create the tables. After that, i am lost as to what to do next and it does not look easy with all of those procedures.

I can't believe that nobody has ever posted the up to date datbase for this starter kit.

Thanks for your help anyway.

Tony

Re: How to re-create Personal.mdf

Cutty — Wed, 15 Apr 2009 06:56:41 GMT

The file worked perfectly for me as well. To add another download spot, I uploaded the file to my host. All you have to do is delete the Personal.mdf and extract both files into the folder and you will be good to go. I am new to this and it took me 2 seconds after I found the file.

Link to file: http://www.icutty.com/pwsk_personal_db.zip

Re: How to re-create Personal.mdf

mlass — Fri, 10 Apr 2009 12:25:12 GMT

Thanks for the file, solved my issue in less than 5 minutes.

Re: How to re-create Personal.mdf

aurrevan — Tue, 03 Mar 2009 21:26:51 GMT

This was the most helpful posting I found on the subject. Thanks

Re: How to re-create Personal.mdf

RaeKC — Sun, 04 Jan 2009 04:47:37 GMT

If that's the one that comes with the starter kit, then it doesn't help. Visual Studio 2008 needs a new version for 2008.

But thanks anyways.

Rachel

Re: How to re-create Personal.mdf

whighfield — Sun, 04 Jan 2009 02:36:46 GMT

Here is the stock *.mdf and *.ldf files for the personal web starter kit.

http://cid-1ca24298b541b070.skydrive.live.com/self.aspx/.Public/pwsk%7C_personal%7C_db.zip?lc=1033

Re: How to re-create Personal.mdf

RaeKC — Sat, 03 Jan 2009 23:47:34 GMT

anyway you could attach the Personal mdf and log files you created?

( am i lazy or what??? i'm just too tired of dealing with this project to try all that again. I did try re-creating the table once without success. )

Rachel

Re: How to re-create Personal.mdf

RaeKC — Sat, 03 Jan 2009 23:43:19 GMT

deleted

Re: How to re-create Personal.mdf

mrshjosey — Sun, 21 Dec 2008 15:40:20 GMT

i have been struggeling along with the recreation also. (and new to all this)

What i did is following:

Delete the personal.mdf file in the server explorer
create a new one by right click on Data connection (add-connection)
Look at the content of the "personal-add.sql" file (in Data-app folder in solution explorer). Here you find what basically is code to create the 2 tables and various Stored-procedures.
Follow the code and create the items by hand. (actually 5 min work)

for all procudures:

right click on "stored procedures" and choose "add-new"
copy/paste each of the 11 procedures as found in de sql(each one starting with CREATE and stopping after each RETURN)

As for the tables:

create new table
colums are called AlbumID, Caption and IsPublic
data type ins int, nvarchar(50) and bit
al ticks are falls (not null)
AlbumID is primary key (right click row for options)

in code in the SQL that looks like

CREATE TABLE [Albums] (
[AlbumID] [int] IDENTITY (1, 1) NOT NULL ,
[Caption] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[IsPublic] [bit] NOT NULL
) ON [PRIMARY]

When done with the 2nd table click relations in the menu and set a relation between AlbumID in de Albums table and the AlbumID field in the Photos table. Set the last 2 options to cascade. Close relations window.
In the sql code this looks like

ALTER TABLE [Photos]
ADD CONSTRAINT [FK_Photos_Albums] FOREIGN KEY ([AlbumID])
REFERENCES [Albums] ([AlbumID])
ON DELETE CASCADE
ON UPDATE CASCADE

All done. I hope this will help and i didnt take the effort for nothing...lol
PS: dont forget to give yourself some admin rights. This is done though the menu “website” option “ASP.NET configuration”. The screen that comes up will explain itself.

Re: How to re-create Personal.mdf

jordanchap — Fri, 05 Dec 2008 03:45:38 GMT

I am new to this whole thing. Could you provide details on how to recreate it for someone like me who doesn't know what they are doing? Thanks!

Re: How to re-create Personal.mdf

Ashley H — Mon, 17 Nov 2008 15:10:09 GMT

petectaylor:

I can't open the personal web site with visual studio 2005 either.

mreaves2008:

I solved this by, deleting the *.mdf file, creating a new database (see above) and creating the tables & stored proc again using the personal-add.sql code in the SQL 2008 mgmt studio.

I have the exact same problem except my SQL mgmt Studio is refusing to connenct to the database saying:

SQL Server:

Logintimeout expired
A Network-related or instance specific error has occurred while establishing a connection to SQL Server. Server is not found or is not accessable. Check if instance name is correct and if SQL Server is configured to allow remote connections.

I have configured SQL to allow remote connections but I am still getting this. I am using SQL Server 2005 Mgmt Studio Express.

Anyone know how to get around this?

Regards,

Ashley H