Upgrade from SQL 2005 EXPRESS to SQL 2008 EXPRESS
-
Hello friends, I restored My database in SQL 2005 of size more than 4 GB but it creates problem when i save picture (image data) in database.i.e i can't save it.So i searched for that problem and came to know that SQL Express 2005 has database size limit of 4 GB. i upgraded it to SQL EXPRESS 2008 and restored it to there.Still it has the same prblem means i can't able to save data.. So what may be the problem. Thanks in advance. RAHUL PATEL. rahulpatel112@live.in
-
Hello friends, I restored My database in SQL 2005 of size more than 4 GB but it creates problem when i save picture (image data) in database.i.e i can't save it.So i searched for that problem and came to know that SQL Express 2005 has database size limit of 4 GB. i upgraded it to SQL EXPRESS 2008 and restored it to there.Still it has the same prblem means i can't able to save data.. So what may be the problem. Thanks in advance. RAHUL PATEL. rahulpatel112@live.in
AFAIK SQL Server Express 2008 and 2005 have the same set of limitations, one of them being file size is 4GB maximum. There are a couple of solutions: - split your database over two or more files; - don't store big objects (images) inside the database (keep them as individual files, just store the path in the DB); - switch to a full-blown DB (SQL Server, non-Express). :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.
-
Hello friends, I restored My database in SQL 2005 of size more than 4 GB but it creates problem when i save picture (image data) in database.i.e i can't save it.So i searched for that problem and came to know that SQL Express 2005 has database size limit of 4 GB. i upgraded it to SQL EXPRESS 2008 and restored it to there.Still it has the same prblem means i can't able to save data.. So what may be the problem. Thanks in advance. RAHUL PATEL. rahulpatel112@live.in
Use Sql Express 2008 R2. That has a size limit of 10GB
"An eye for an eye only ends up making the whole world blind"
-
Use Sql Express 2008 R2. That has a size limit of 10GB
"An eye for an eye only ends up making the whole world blind"
I learn something new each day. 10GB is confirmed here[^]. :thumbsup:
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.
-
I learn something new each day. 10GB is confirmed here[^]. :thumbsup:
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.
Thanks for your reply. i upgraded sql 2005 express to sql 2008 EXPRESS WITH TOOLS that is R2 version of SQL EXPRESS. But still the same problem there....
-
Thanks for your reply. i upgraded sql 2005 express to sql 2008 EXPRESS WITH TOOLS that is R2 version of SQL EXPRESS. But still the same problem there....
Then I suggest you provide a detailed and accurate problem description: describe your set-up, show the failing code and the observations or error messages with all their detail. That should allow people to give a precise answer. We need more than "it doesn't work". :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.
-
Hello friends, I restored My database in SQL 2005 of size more than 4 GB but it creates problem when i save picture (image data) in database.i.e i can't save it.So i searched for that problem and came to know that SQL Express 2005 has database size limit of 4 GB. i upgraded it to SQL EXPRESS 2008 and restored it to there.Still it has the same prblem means i can't able to save data.. So what may be the problem. Thanks in advance. RAHUL PATEL. rahulpatel112@live.in
-
Use Sql Express 2008 R2. That has a size limit of 10GB
"An eye for an eye only ends up making the whole world blind"
Thanks a lot dear friends for your valuable time. I have installed SQL EXPRESS 2008 but it was not EXPRESS R2 version thats why its creating problem. I came to know that thing when i was changing the initial size of database to 5500 MB. Thankx.