Hot answers tagged

4

In your scenrio before migration make sure following things. both sharepoint farm are on the same version level. all the custom solution deployed to test farm as they are in production authentication is properly configured in the test as you did in prod. Now for Content DB of web app. take the backup of content db from production web app restore it on ...


3

If you didn't had a page already existing with name = "WelcomeNew", then people will try to access site and get Page Not Found error. An Ideal SharePoint approach is a follows Create an External Content Type (ECT) and use this to connect to you SQL Server In ECT you can define methods which you want to act on the backend (Ex: SQL Table) Read All Items ...


3

Whilst a content database can contain more than one site collection. A site collection however, can contain only one content database. RBS can be used to prevent database growth as it stores data in physical location. See more about RBS here: https://technet.microsoft.com/en-us/library/ee748649.aspx?f=255&MSPPError=-2147217396


2

No, You cant have one site collections in more than one content DB. Yes, you can use the RBS to increase the database storage. If your site collection grow beyond the 200GB(i am guessing you hreach 200GB not 4Tb) limit, i would highly recommend that perform the cleanup operation on the site collection and delete the unwanted stuff. Or split the site into ...


2

It is not possible. You need Microsoft SQL Server. More info in Hardware and software requirements for SharePoint 2013. Technet.


2

You can do it without Visual Studio, but it's not as secure. As for the non-VS methods, a few notes: JavaScript is client-side code, which means potentially exposing your encryption method to the end user. If you go with the method of having the database encrypt it (passing the string to a stored procedure which then encrypts it and puts it wherever you ...


2

In SharePoint querying of lists is done using CAML query instead of SQL queries. Tools like CAML Query Helper and U2U CAML Query builder can be used to generate your query and to test it. Check this post on creating Visual Webparts for SharePoint 2010 Now you can use below code as a starting point for reading data from list. using (SPSite site = new ...


2

IMO, you're looking forward to a lot of problems if you really want to push all this data into SharePoint lists! First, you're hitting a number of hard or soft limits in SharePoint : no more than 5000 items per view, no more than 200GB per content DB, no more than 12 lookups in a query, etc. Second, conceptually, SharePoint is not a replacement for a ...


1

If the database seem to be "readonly" as you say, I think it may have been put in "Suspect" state after some issue occurred on the machine. When SQL Server thinks a database may have entered an invalid state, the "Suspect" state may be triggered - I had it once happen on a development virtual machine that was turn down during a web application creation and ...


1

Database first approach using EF with external database , the steps are more or less same as in any plain .NET project. You can look at below blogs: https://www.asp.net/mvc/overview/getting-started/database-first-development/setting-up-database http://www.asp.net/mvc/overview/getting-started/database-first-development/creating-the-web-application To get ...


1

It is not possible to run it using MySQL server. You can use express edition for simple tasks but if your databases go more than 4GB I suggest you use many web apps instead (divide the work). For big companies it will be impossible to use SQL express edition so you would have to buy SQL Server. MySQL is not an available solution.


1

I realize this is a old post but I have come across the same issue and a solution. For my SP 2013 farm we use AlwaysOn in SQL 2012 for our databases. For reasons I haven't been able to figure out the primary SQL server fails over to the secondary and this issue pops up with only the Subscription settings service database. I failover again making my 01 ...


1

You can reduce the retention period How-to...


1

I am in the process of doing the exact same thing. Although the architecture will remain exactly the same, my biggest concern was upgrading the custom solutions to SP2010 (Workflows, Visual Studio solutions, customized pages, XSL stylesheets etc). There are too may parameters for what you are asking. I would personally ask why you want to split the ...


1

Yes, new site collections and additional content databases are supported in SharePoint 2007. The problem you are going to encounter in either 2007 or 2010 is that there is no quick way to restructure/move your current subsites between site collections. You can't do it with the Site Manager (aka Manage Content and Structure) because that is scoped to a site ...


1

Yes it is possible. You can have multiple databases attach to a web application(500 is limit). You can have the many site collections and provision one site collection into one content DB. Read more about the limits here. https://technet.microsoft.com/en-us/library/cc262787(v=office.15).aspx#ContentDB


1

When using RBS what is the total size limit that can be uploaded to SharePoint? Is there any size limitation concerning the data? Per file: The absolute maximum size per file that can be uploaded is 2GB - RBS does not change this. Per content db: The standard 200GB (on SP2010 and 2013) or 100GB (on SP2007) includes both the data within the SQL db (i.e. ...



Only top voted, non community-wiki answers of a minimum length are eligible