Last post Mar 29, 2008 10:11 AM by TATWORTH
Feb 25, 2008 01:56 PM|markgrant|LINK
HI i am running the personal web starter site and have managed to fill up the personal sql database even with compressing photos before uploading, is it possible to add another one? What i had in mind was if so to create databases for the years, so 2006
2007 2008 etc. then when a user goes to the albums page he can select a database / year.
Im no expert and dont even know if this is possible, Apologies if this topic has been covered before i tried a search but couldnt find anything related.
Feb 25, 2008 08:00 PM|norchnou|LINK
Just click on the server explorer and then right clik on the default db then add an other db
Mark as answer ifit solved your problem
Feb 26, 2008 03:14 PM|markgrant|LINK
Feb 26, 2008 10:11 PM|norchnou|LINK
I wont be able to help you on that,
all I can tell is that you like headaches, unless you have a very good reason to; you should use 1 db even on the hosting server it will slow you.
Mar 23, 2008 01:44 PM|newbie2C#|LINK
There might be some T-SQL statements that can be used to alter the maxsize of the database. This is a guess but probably worth looking into.
Another solution would be to build a new db that would allow a larger maximum size. Then use this new one for your project. These are the properties that you can change when building a new one. Setting the maxsize to number that you think will allow enough
room for future growth should do it. The numbers here are only for illustration purposes.
SIZE = 5MB, MAXSIZE = 100MB, FILEGROWTH = 5MB
MAXSIZE = 100MB,
FILEGROWTH = 5MB
If you do a search on how to script a SQL Server database using T-SQL you will see the properties that I listed above. It is actually very easy to do. There is one thing that i can think of that will be a problem. I think it will be pretty
easy to overcome if you are careful though. You want to make sure the you naming convention for the tables, columns and your datatypes are the same as the one that came packaged with the Starter Kit. Otherwise the sql statements won't work
Mar 23, 2008 03:13 PM|TATWORTH|LINK
> I know i would have to find a way from the admin pages to upload to the correct database im hoping you can map a dropdown box or something. would this be possible
All the data should be in the same database, unless the volume of data is such that the the database has to be split.
Mar 29, 2008 10:11 AM|TATWORTH|LINK
If your question has been answered, please mark the post as closed.