The only reason is that your contents are still residing in SP Content database. Just verify following URL once and check whether you skipped deleting items from this locations.
SiteUrl/_layouts/15/AdminRecycleBin.aspx?view=2 is the ...
As James mentions it's not a valuable comparison as it's two completely different tools. No "SharePoint is not a database" and no "SQL is not a collaboration, document management, ... platform".
But to answer your question only point 7 and 8 has been changed (fixed) in SP2013.
For more information: Here is my take on the eight points:
Primary and foreign ...
Make sure that you have deleted the items in Site Collection Recycle Bin
Once the document is deleted it moved to 1st stage recycle bin. It stays there based on the web application recycle bin setting that (default is 30 days). after this period finished (30 days) it moved to 2nd stage recycle bin it also called Site Collection Recycle Bin.
In 2nd ...
James is so right, it's not SharePoint vs SQL Server, it's a matter of using the right tool for the right business needs but to go deeper in these assumptions
Cascading Delete / Primary & Foreign Keys are available since SP2010 and handled through built-in features like :
Unique Column policy
Joins between lists
Apologies if this doesn't directly answer your questions, but I think the main point to be made here is that SQL databases and Microsoft SharePoint solve two completely different issues.
Can you store documents and collaborate with people using SQL out of the box?
Can you find colleagues with similar skills, interests who have uploaded documents you are ...
The procedure described in these articles should work just fine. I've done this multiple times.
You don't need to install the SQL Management or Client Tools on every SharePoint server. Just us the cliconfg.exe program to setup the alias. You can find more information on my blog at:
The search database is not a content database. You need to upgrade using the SharePoint 2010 Farm Configuration Wizard. I would run that and see where it gets you and then you can find any errors in the upgrade logs.
Here is a link to help.
•Open a command box ...
Don't touch the database, but instead of deleting items from 2nd stage Recycle Bin using PowerShell, try disabling it from Central Admin first before running the PS script:
Central Administration > Application Management > Web Application General Settings > Set Recycle Bin > Second stage Recycle Bin > OFF
Or using PS:
Where does SharePoint list stores data in SQL?
In SharePoint Content DataBase at AllLists INNER JOIN AllUserData ON AllLists.tp_ID = AllUserData.tp_ListId where the data stored at AllUserData.tp_ColumnSet column as XML
Can I access data directly and is it recommended?
No, it's not recommended and not supported and I advise you
to don't touch the ...
AFAIK, using the existing services; it is not possible to access the content database informations from Client Object model or services. As a work around you can create your own WCF service and deploy it in SharePoint, which can provide your required data.
How to Customize WCF Services in SharePoint 2010
SharePoint 2010: Create Custom WCF Service
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:
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 ...
You must use cliconfg.exe on each SharePoint server to point the 'old' SQL Server name (and instance if applicable) to the new SQL Server name (and instance if applicable). So if you had an old SQL Server name of OLDSQL and a new one of NEWSQL, you would run cliconfg.exe on each SharePoint server, go to the Alias tab, add an alias named OLDSQL. Set it to TCP/...
There are many possible answers to this. Here are a few:
Create a sharepoint list with approval turned on (list settings), and use a flow to handle the multiple approvers. Upon approval, the flow could add a new list item in the calendar list
Do the above, but also add fields to the form for the approver name, approver comments, approval date, etc. At this ...
READ COMMITTED SNAPSHOT ISOLATION is not supported by SharePoint. Review the presentation below by Lisa Gardner from the PASS Summit back in 2012 for more details.
You'll likely want the SharePoint Products and Technologies Protocol Documentation. These contain descriptions about the database structure, including table schema, sprocs, and so forth... Along with a lot of other information. And as everyone else has noted, making changes is, for the most part, unsupported. Check out KB841057 for more information on ...
you have the old db-server up and running, use the following command in PowerShell:
Get-SPSite -ContentDatabase <SourceContentDb> | Move-SPSite -DestinationDatabase <DestinationContentDb>
This command moves all site collections from the source content database to the destination content database.
Reference: Move site collections between ...
As per the Microsoft KB articles, which applies to all SharePoint Versions, always against direct access to SharePoint database.
here are the supported scenarios:
Supported database modifications
Exceptions to the prohibition against database modifications are made for specific usage scenarios:
Operations that are initiated from the SharePoint ...
Delete your web application.
Create a new one. Take care that the authentication mode is identical with the initial web application in which your backed up site collection has been created. Do not directly assign your restored content database but let Sharepoint create a new (empty) content database.
Next, from your Central Administration => Application ...
If you navigate to Central Administration >> Monitoring >> Reporting: Configure Diagnostic Logging. You can configure logging to be less verbose, turn off logging for features you may not need, and limit the amount of space it consumes.
See this link for a reference: http://technet.microsoft.com/en-us/library/ee748656(v=office.15).aspx
SQL server by DESIGN will always eat up as much ram as you throw at it if you have databases of sufficient size. Have a 32GB database and 32GB of memory ... SQL by default will eat all of it.
You can configure SQL to limit the amount of memory it will consume however. Lets say you have 16GB of memory in your system try limiting the SQL buffer to 10GB, that ...
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 ...
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
Based on your description, you don't have a complex ERD, it just one table to archive your project.
So It recommended creating a SharePoint list instead of building a new database then develops UI forms to add, edit, delete and update your project date from scratch. I think it will waste your time.Meanwhile, it doesn't provide a list OOTB capability like:
You first need to go the SQL Server where you Database is located.
Open the SQL Server Management Studio.
Go to you required DB and right click to get "Properties".
Click on ellipses as shown in red.
you will get a window as below.
You can change as per your requirement.
Be sure when you change.
It is supported to virtualize the SQL Server, but we cannot make a specific recommendation for you as that would require knowing the performance of the hardware, required overhead, and so on. The best thing you can do is verify the virtualized hardware can support the existing load + some overhead of your SQL instance.
As far as the recommended route, you ...
Certain tables are supported for reading directly from the database in Project Server only (this extends to the Content Database where Project Server data resides in 2016/2019), namely the database that were previously present in the Project Server 2013 Reporting database.
See the section titled Project Server database in Project Server architecture.
the best way to do this is to configure BCS (Business Connectivity Service) to fetch data from external database to SharePoint and than work on the lists and libraries SharePoint.
Here are some articles to read:
Yes it is possible. (based on readings, I never done it myself)
You will need to create WCF web services and then use them as external content in your BCS to create an external list in your SharePoint environment (which I assume is SP 2010).
Or you can utilize StreamAccessor as explained in article below,
Accessing BLOB Data from External Systems Using ...