RE: WSS 3.0 SQL Express 4GB limit
What about SQL2005 embedded (Windows Internal DB/WYukon) rathern than express - no limit AFAIK if you have the right Server (2008) and you have it on the same box as wss3 - it is free with unlimited storage. Also, Express 2008 now comes with a 10GB limit - so RBS may not be needed. And Free EBS (deprecated, but still used widely) providers are out there if you must stay on SQL 2005. However, better off to move to a newer platform if possible, and RBS can get you ouf of an specific DB size issue as long as you plan your backups well and understand its limitations. Not a lot of people seem to know all this, which is strange! Mike. From: wmacdon...@like10.com To: ozmoss@ozmoss.com Subject: RE: WSS 3.0 SQL Express 4GB limit Date: Tue, 8 Feb 2011 09:24:49 + Supported Upgrade Paths for SQL 2008 R2 http://technet.microsoft.com/en-us/library/ms143393.aspx How to Upgrade http://technet.microsoft.com/en-us/library/ms144267.aspx Wes From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Uzma Naz Sent: Tuesday, February 08, 2011 4:05 AM To: ozmoss@ozmoss.com Subject: RE: WSS 3.0 SQL Express 4GB limit Hi Tom, I don't think the Client wants to go down the path of a new server/build. I will need to set up a testing envrionment to ensure that SQL 2005 Express can be upgraded to SQL 2008 Express seamlessly! (If you guys have any links/tips, let me know!) Uzma From: tom...@macroview.com.au To: ozmoss@ozmoss.com Subject: RE: WSS 3.0 SQL Express 4GB limit Date: Mon, 7 Feb 2011 22:35:45 + Uzma, Why not upgrade to SharePoint Foundation and use remote blob storage? Then your database will not be so big etc. Regards, Tom Bizannes SharePoint and SQL Specialist From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Uzma Naz Sent: Monday, 7 February 2011 10:38 PM To: ozmoss@ozmoss.com Subject: WSS 3.0 SQL Express 4GB limit Hi there, I was wondering.. is it possible to create a new content database to generate a further 4GB of space within a stand alone, WSS 3.0 environment with SQL Express installed? Uzma ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: WSS 3.0 SQL Express 4GB limit
I've had a lot of good experiences with the AvePoint product for the RBS stuff, easy to implement and configure and very effective. Using the filestream provider is a bit more hands on to configure but not too bad (there are good blog posts around on it, Todd Klindt had a good one from memory), but that is free so worth looking at if you are on a tight budget. Regards, Brian Farnhill Microsoft SharePoint Server MVP Microsoft Virtual Technical Solutions Professional Blog: http://blog.brianfarnhill.comhttp://blog.brianfarnhill.com/ | Twitter: @BrianFarnhillhttp://twitter.com/BrianFarnhill | Mobile: 0408 289 303 Canberra SharePoint User Group: http://www.sharepointusers.org.au/Canberra SharePoint Saturday Events: Sydneyhttp://www.sharepointsaturday.org/Sydney | Canberrahttp://www.sharepointsaturday.org/Canberra | Melbournehttp://www.sharepointsaturday.org/Melbourne From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Culmsee Sent: Tuesday, 8 February 2011 10:36 AM To: 'ozMOSS' Subject: RE: WSS 3.0 SQL Express 4GB limit Hiya Out of interest, who is using RBS? Coming from enterprise DMS systems before working with SharePoint, I have long held the view that SQL was not the place for documents. SharePoint people often find the concept foreign but it's the prevailing wisdom in many other ECM systems out there. Nevertheless, I haven't taken the plunge yet but I have a client in mind as part of a soon to happen upgrade to 2010. Has it been solid? These days I am the kind of guy who like grandpa, laments increased complexity and yearns for the simplicity of the past. Has anybody had negative experiences? Regards Paul From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Tom Bizannes Sent: Tuesday, 8 February 2011 6:36 AM To: ozMOSS Subject: RE: WSS 3.0 SQL Express 4GB limit Uzma, Why not upgrade to SharePoint Foundation and use remote blob storage? Then your database will not be so big etc. Regards, Tom Bizannes SharePoint and SQL Specialist From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Uzma Naz Sent: Monday, 7 February 2011 10:38 PM To: ozmoss@ozmoss.com Subject: WSS 3.0 SQL Express 4GB limit Hi there, I was wondering.. is it possible to create a new content database to generate a further 4GB of space within a stand alone, WSS 3.0 environment with SQL Express installed? Uzma ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: WSS 3.0 SQL Express 4GB limit
Hi Tom, I don't think the Client wants to go down the path of a new server/build. I will need to set up a testing envrionment to ensure that SQL 2005 Express can be upgraded to SQL 2008 Express seamlessly! (If you guys have any links/tips, let me know!) Uzma From: tom...@macroview.com.au To: ozmoss@ozmoss.com Subject: RE: WSS 3.0 SQL Express 4GB limit Date: Mon, 7 Feb 2011 22:35:45 + Uzma, Why not upgrade to SharePoint Foundation and use remote blob storage? Then your database will not be so big etc. Regards, Tom Bizannes SharePoint and SQL Specialist From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Uzma Naz Sent: Monday, 7 February 2011 10:38 PM To: ozmoss@ozmoss.com Subject: WSS 3.0 SQL Express 4GB limit Hi there, I was wondering.. is it possible to create a new content database to generate a further 4GB of space within a stand alone, WSS 3.0 environment with SQL Express installed? Uzma ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: WSS 3.0 SQL Express 4GB limit
Supported Upgrade Paths for SQL 2008 R2 http://technet.microsoft.com/en-us/library/ms143393.aspx How to Upgrade http://technet.microsoft.com/en-us/library/ms144267.aspx Wes From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Uzma Naz Sent: Tuesday, February 08, 2011 4:05 AM To: ozmoss@ozmoss.com Subject: RE: WSS 3.0 SQL Express 4GB limit Hi Tom, I don't think the Client wants to go down the path of a new server/build. I will need to set up a testing envrionment to ensure that SQL 2005 Express can be upgraded to SQL 2008 Express seamlessly! (If you guys have any links/tips, let me know!) Uzma From: tom...@macroview.com.au To: ozmoss@ozmoss.com Subject: RE: WSS 3.0 SQL Express 4GB limit Date: Mon, 7 Feb 2011 22:35:45 + Uzma, Why not upgrade to SharePoint Foundation and use remote blob storage? Then your database will not be so big etc. Regards, Tom Bizannes SharePoint and SQL Specialist From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Uzma Naz Sent: Monday, 7 February 2011 10:38 PM To: ozmoss@ozmoss.com Subject: WSS 3.0 SQL Express 4GB limit Hi there, I was wondering.. is it possible to create a new content database to generate a further 4GB of space within a stand alone, WSS 3.0 environment with SQL Express installed? Uzma ___ ozmoss mailing list ozmoss@ozmoss.commailto:ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: WSS 3.0 SQL Express 4GB limit
+1 to AvePoint and RBS. We are rolling this out on a few customers at the moment primarily due to being able to store the documents outside of SQL onto cheaper storage for them. From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Brian Farnhill Sent: Tuesday, 8 February 2011 4:19 PM To: paul.culm...@sevensigma.com.au; ozMOSS Subject: RE: WSS 3.0 SQL Express 4GB limit I've had a lot of good experiences with the AvePoint product for the RBS stuff, easy to implement and configure and very effective. Using the filestream provider is a bit more hands on to configure but not too bad (there are good blog posts around on it, Todd Klindt had a good one from memory), but that is free so worth looking at if you are on a tight budget. Regards, Brian Farnhill Microsoft SharePoint Server MVP Microsoft Virtual Technical Solutions Professional Blog: http://blog.brianfarnhill.comhttp://blog.brianfarnhill.com/ | Twitter: @BrianFarnhillhttp://twitter.com/BrianFarnhill | Mobile: 0408 289 303 Canberra SharePoint User Group: http://www.sharepointusers.org.au/Canberra SharePoint Saturday Events: Sydneyhttp://www.sharepointsaturday.org/Sydney | Canberrahttp://www.sharepointsaturday.org/Canberra | Melbournehttp://www.sharepointsaturday.org/Melbourne From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Culmsee Sent: Tuesday, 8 February 2011 10:36 AM To: 'ozMOSS' Subject: RE: WSS 3.0 SQL Express 4GB limit Hiya Out of interest, who is using RBS? Coming from enterprise DMS systems before working with SharePoint, I have long held the view that SQL was not the place for documents. SharePoint people often find the concept foreign but it's the prevailing wisdom in many other ECM systems out there. Nevertheless, I haven't taken the plunge yet but I have a client in mind as part of a soon to happen upgrade to 2010. Has it been solid? These days I am the kind of guy who like grandpa, laments increased complexity and yearns for the simplicity of the past. Has anybody had negative experiences? Regards Paul From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Tom Bizannes Sent: Tuesday, 8 February 2011 6:36 AM To: ozMOSS Subject: RE: WSS 3.0 SQL Express 4GB limit Uzma, Why not upgrade to SharePoint Foundation and use remote blob storage? Then your database will not be so big etc. Regards, Tom Bizannes SharePoint and SQL Specialist From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Uzma Naz Sent: Monday, 7 February 2011 10:38 PM To: ozmoss@ozmoss.com Subject: WSS 3.0 SQL Express 4GB limit Hi there, I was wondering.. is it possible to create a new content database to generate a further 4GB of space within a stand alone, WSS 3.0 environment with SQL Express installed? Uzma ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: WSS 3.0 SQL Express 4GB limit
You could always upgrade to SQL 2008 R2 Express which has a limit of 10Gb. Wes From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Uzma Naz Sent: Monday, February 07, 2011 6:38 AM To: ozmoss@ozmoss.com Subject: WSS 3.0 SQL Express 4GB limit Hi there, I was wondering.. is it possible to create a new content database to generate a further 4GB of space within a stand alone, WSS 3.0 environment with SQL Express installed? Uzma ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: WSS 3.0 SQL Express 4GB limit
Uzma, Why not upgrade to SharePoint Foundation and use remote blob storage? Then your database will not be so big etc. Regards, Tom Bizannes SharePoint and SQL Specialist From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Uzma Naz Sent: Monday, 7 February 2011 10:38 PM To: ozmoss@ozmoss.com Subject: WSS 3.0 SQL Express 4GB limit Hi there, I was wondering.. is it possible to create a new content database to generate a further 4GB of space within a stand alone, WSS 3.0 environment with SQL Express installed? Uzma ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: WSS 3.0 SQL Express 4GB limit
Hiya Out of interest, who is using RBS? Coming from enterprise DMS systems before working with SharePoint, I have long held the view that SQL was not the place for documents. SharePoint people often find the concept foreign but it's the prevailing wisdom in many other ECM systems out there. Nevertheless, I haven't taken the plunge yet but I have a client in mind as part of a soon to happen upgrade to 2010. Has it been solid? These days I am the kind of guy who like grandpa, laments increased complexity and yearns for the simplicity of the past. Has anybody had negative experiences? Regards Paul From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Tom Bizannes Sent: Tuesday, 8 February 2011 6:36 AM To: ozMOSS Subject: RE: WSS 3.0 SQL Express 4GB limit Uzma, Why not upgrade to SharePoint Foundation and use remote blob storage? Then your database will not be so big etc. Regards, Tom Bizannes SharePoint and SQL Specialist From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Uzma Naz Sent: Monday, 7 February 2011 10:38 PM To: ozmoss@ozmoss.com Subject: WSS 3.0 SQL Express 4GB limit Hi there, I was wondering.. is it possible to create a new content database to generate a further 4GB of space within a stand alone, WSS 3.0 environment with SQL Express installed? Uzma ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss