Questions tagged [sql-database]
Question about the Sitecore SQL databases - content, reporting, sessions, ...
98
questions
1
vote
1answer
102 views
Cannot open database error every time
I have a local Sitecore 8.2 instance.
Whenever, I browse this instance for the first time in a day or each time I deploy a dll, it throws this error:
Cannot open database "MySiteSitecore_Web" ...
1
vote
0answers
33 views
How to execute stored procedure using Sitecore.Data.DataProviders.Sql.SqlDataApi
I am trying to execute SQL stored procedure from C# code using Sitecore data providers. I am using the SqlDataApi class from Sitecore.Data.DataProviders.Sql but not finding any method which accepts a ...
0
votes
0answers
30 views
Where should you add a custom Connection String? In the ConnectionStrings.config? [duplicate]
Or would it be a bad idea to make any custom edits to ConnectionStrings.config as part of a new update?
In that case would it be best to keep the custom DB Connection String in a totally new custom ....
4
votes
0answers
31 views
Is the Session DB Performance Boost still necessary?
I see that the section on optimizing SQL Session DB Performance that existed in the Sitecore 8.1 documentation no longer exists in the documentation for 9.1.
Is this because the step is no longer ...
0
votes
1answer
43 views
Access Rights required for Session database
I configured private and shared session using SQL Provider, following this link After I deployed the Sitecore.Sessions.dacpac file, I tried to create a user for the database but it was failing with ...
1
vote
2answers
96 views
Best practices - Sitecore website in Prod - local or remote Sitecore databases?
Judging by how SIM works, and how pervasive SIM is... I assume the most common practice for QA and Prod, is the Database is local/on the same machine as the website.
Is this indeed the suggested/...
2
votes
1answer
234 views
Where does SIM install the databases when installing a new Sitecore instance?
This must be documented somewhere but I'm not finding any good documentation on what SIM does when you install Sitecore 8.2 with it.
I understand it creates a new web root folder on your local ...
4
votes
1answer
117 views
How To: Refresh environment A(QA) from environment B(Prod) after they're out of sync
I'm sure you've been in this spot. Client has a QA and a Prod environment, but over time they stopped using best practices, and they have only been authoring content/template changes in Prod, nothing ...
2
votes
3answers
214 views
msdeploy.exe : Error: .Net SqlClient Data Provider: Invalid object name 'Blobs'
I'm trying to install Sitecore Commerce v9.2. I had a few issues that I solved earlier. However, right now I'm getting a database error.
When I check the database I can see two new Commerce ...
0
votes
0answers
70 views
Application Insights sql dependency error on History_GetTaskStateById
When looking into application insights a see most of the errors coming from:
SQL: [xdb_processing_tasks].[History_GetTaskStateById]
Returning error 50000 running Sitecore 9.0.2. The stored procedure ...
1
vote
3answers
153 views
What is the purpose of Reference Database and Share Databases in Sitecore 9.x?
Sitecore 9.2
Once we installed Sitecore 9.x we can find reference database (sitecoreInsatnceName_ReferenceData) and share databases (sitecoreInsatnceName__Xdb.Collection.Shared0,...
0
votes
2answers
209 views
How to remove media item from both blobs table and items table at the same time from sitecore master db?
I have added some images in sitecore media library. Those images are getting added in both dbo.Blobs and dbo.Items tables. I wanted to delete the image data from both the tables.But I don't know how ...
0
votes
2answers
275 views
Installation Sqlcmd: Error - The client cannot connect to the server because the requested instance was not available [duplicate]
I'm trying to install Sitecore 9.1 Update 1 on my local machine. The script actually installs 7 databases like (MarketingAutomation, Messaging, Reporting), however when it comes to Sitecore databases ...
1
vote
0answers
30 views
Error setting up mirroring on SQL databases after Sitecore upgrade
We have upgrade our website from Sitecore 8.2 to 9.1.1. As per sitecore upgrade guide I installed the XConnect separately and also restored Messaging, Processing Pools databases using dacpac files. I ...
2
votes
1answer
48 views
Sitecore Desktop database selection shows non-existent database
On my instance of Sitecore 8.2 Update 7, the database selection list in the lower right hand corner show two webs:
There is only one web in publishing targets:
And my connection strings only have ...
0
votes
1answer
45 views
What is the significance of end of Mainstream Support on SQL 2014 SP2 for Sitecore 8.x
According to Microsoft SQL 2014 SP2 loses Mainstream Support from Microsoft in July 2019. (https://support.microsoft.com/en-us/lifecycle/search/17645)
Many Sitecore environments utilize this version ...
0
votes
0answers
39 views
Mapping tables for Mongo Db “Interactions” Collections in sitecore reporting DB
We have the requirement like build the custom dashboard for page visits & clicks using sql reporting database, how to map the existing mongo db collection called "interactions" with reporting db ...
1
vote
0answers
38 views
Sitecore 8.2 update 3 mongodb conversion into sql server reporting db
We are using the Sitecore 8.2 update 3 version with MongoDB.
The data is being captured in the MongoDB but Fact_Conversions table has no data.
What actually is to be done to have data in this table....
0
votes
3answers
222 views
Core and Master databases keep falling under recovery_pending state
We are on an upgraded instance and restoring Core and Master databases from an already running environment to a new one we are building.
After the DB restore as soon as we start the app pool and ...
2
votes
2answers
80 views
Should TransientRetryer be enabled for SQL Azure?
In Sitecore.config for Sitecore 9.0.2 I see the following comment:
<!-- RETRYER
Example transient retryer:
<retryer disabled="false" type="Sitecore.Data.DataProviders....
0
votes
0answers
55 views
Eventqueue query crashing the CD site
I have a single CD CM 8.2 instance of sitecore.
We have a job that is running at a particular time everyday which publishes around a 1000 items. Our CD server crashes everytime the job runs and the ...
1
vote
1answer
245 views
Secure Azure SQL database connection using a managed identity
We are currently hosting our Sitecore 9.1 initial release on premises, but want to move the complete solution into Azure. We want to use public services and not put our solution in an ASE. To secure ...
2
votes
1answer
124 views
YSOD When trying to open the login page - “No process is on the other end of the pipe” [closed]
I have 12 different instances (test purpose only) using this same SQL Server.
All of the sudden, one of those (which was working fine until yesterday) started giving me this error when I try to open ...
1
vote
3answers
253 views
Can SC_TICKET* keys be purged from the Properties table, and have tickets been moved elsewhere?
I'm troubleshooting an issue with slow logins on a Sitecore instance.
As part of that investigation I've found a number of posts - such as Sitecore client and logon is very slow (properties table ...
1
vote
1answer
141 views
Why is it important to have Core DB in Content Delivery Environment if i have static content sites?
What is the significance of having core database in CD Environment and which are all tables being used from CD Environment?
Do we really need core DB for the below scenario?
Sites are only ...
0
votes
1answer
37 views
Get WFFM values and transpose them into Pivot table
I have a situation where I am stuck to create a query for fetching data from Wffm DB as Pivot, so please help
FieldName Value
--------------------------------
FirstName Joe
MiddleName S
...
0
votes
1answer
245 views
Does sitecore 9.0.2 supports Azure SQL managed instance(Azure SQL Paas)?
Does sitecore 9.0.2 supports Azure SQL managed instance(Azure SQL Paas) ?
8
votes
2answers
719 views
Move users / roles / passwords to new core database
We are migrating from Sitecore 8.2 to 9.0.2 and decided to start with "fresh" core, web, and master databases, migrating content on top of blank databases.
What is the most efficient method to ...
0
votes
1answer
387 views
User Profile table in SQL
I am saving a user profile and one of the field is "UserLanguage" which is saving fine
Context.User.Profile.Save();
The save method is working as expected but where the User Profile being saved in ...
3
votes
1answer
239 views
SQL Azure Master DB - masteruser password discrepancies
I have 2 Sitecore 9.02 Scaled Azure environments.
They are PROD and UAT. All the databases are SQL Azure.
The marketing team have been adding a lot of content on PROD and I want to take a bacpac of ...
1
vote
0answers
179 views
Rebuilds Links Database exception: This SqlTransaction has completed; it is no longer usable
When attempting to rebuild the links database on the master database I'm getting the following exception:
Job started: RebuildLinkDatabasesIndex|System.InvalidOperationException: This SqlTransaction ...
0
votes
1answer
173 views
Where is the value “Item owner: sitecore\smith” from “Quick Info” living in back-end SQL tables?
I'm unable yet to locate a particular "Item owner: sitecore\smith" value I see well-and-alive in Content Editor "Quick Info" of an item, but not in the SQL Server backend tables.
I often pull a ...
0
votes
1answer
21 views
Sitecore DB: Can't delete Preview DB table from SQL Server 13.0.400
I first duplicated the original Sitecore Web DB and just renamed to Sitecore Preview DB.
Now that I noticed I accidentally copied the Sitecore Master DB instead of Web DB and I am trying to delete the ...
3
votes
1answer
428 views
xConnect cannot reach SQL Server
I noticed no data was being generated in the Experience Profile. I went to the site and tried to generate some test data by filling out a form and received an error "Updating Contact Failed". I ...
2
votes
1answer
281 views
Sitecore 9 Update 2 - Azure Database Type and Sizes
We are in process of designing the infrastructure architecture to host sitecore 9 update 2 in azure. This requires us to appropriately size all the databases for Sitecore 9. Also I can't find any ...
3
votes
0answers
106 views
Sitecore 9.0.2 Installation with SQL Windows Authentication [duplicate]
We need to install Xconnect Xp0 instance (Sitecore 9.0.2) with SQL Windows Authentication, We don't have access to the SQL Server with SQL Authentication enabled.
Can you Please help what all changes ...
5
votes
2answers
524 views
Why Sitecore 9 xDB on SQL server 2016?
My curiosity is to know more about the features which Microsoft has provided in the SQL server 2016 version which also allows the Sitecore to implement the xDB on the SQL Server 2016 itself, which ...
0
votes
2answers
329 views
What are the databases Installed by Sitecore Experience Commerce 9.0.2?
My motive behind asking this is, trying to understand the roles and responsibilities of each databases and differentiate them from the other database(Sitecore Experience Platform).
7
votes
1answer
509 views
Why Xdb.Collection.Shard0, Xdb.Collection.Shard1 and Xdb.Collection.ShardMapManager databases in Sitecore 9 are not Partially Contained?
I am wondering what are the reasons or maybe technical limitations all of Sitecore 9 databases to be Partially Contained except Xdb.Collection.Shard0, Xdb.Collection.Shard1 and Xdb.Collection....
2
votes
1answer
399 views
Rundown of Sitecore 9 XP SQL databases?
Could someone provide a rundown of Sitecore 9 XP SQL Server databases and their purpose? For example "Xdb.Processing.Pools"?
5
votes
1answer
217 views
Migrate SQL DB to Azure SQL
We are facing issues while moving an existing Sitecore master db from an on premise SQL Server instance to an Azure SQL Server. The BACPAC file is almost 5 GB.
The above error appears on
- Enabling ...
20
votes
2answers
2k views
Mongo vs SQL Server with Sitecore 9 Update 2
Sitecore recently launched the version 9.0.2 which supports the MongoDB for xConnect.
Now, for a greenfield project which needs to kickoff on Sitecore 9.0.2, we have a choice between MS SQL Server or ...
3
votes
2answers
223 views
Which databases does Sitecore 9.0.2 need for CMS only mode?
We are looking to roll out a deployment of Sitecore 9.0.2 in CMS only mode. Does it need all databases to run or can it work off:
Core
Master
Web
I'm happy we can run session inProc (provided thats ...
0
votes
1answer
57 views
Delete old records from WFFM 2.4 configured with Sitecore 7.2
We are using WFFM 2.4 with Sitecore 7.2 and have "save to database" action in many forms.As WFFM database size is more then 21 GB now, I am looking a script to remove old records. Please share if same ...
1
vote
0answers
64 views
Sitecore 8.1 with SQL Always ON
I know Sitecore 8.1 is not compatible with SQL Always ON as per Sitecore documentation. That is a feature released with 8.2.
But, would anybody know why specifically it wouldn`t work?
Thank you
2
votes
1answer
160 views
Why Sitecore 9 Azure installation having 5 different database ? Not able to connect to these database using local SQL MS (Sitecore PaaS)
When sitecore 9 using new Azure setup has been installed there are 5 different database servers. I want to know why we have different database for Forms and individual database servers.
Also I am ...
1
vote
2answers
78 views
Can I have/install 2 sets of Sitecore databases on the same database server (SQL)?
I am planning to share the same AWS RDS (SQL) for 2 different sets of Sitecore databases. So I will have 2 Webs, 2 Cores and 2 Masters DB. Could anyone confirm if this is possible? Why or why not? The ...
3
votes
1answer
338 views
How to find out how many items are in media folder by querying the db
Is there a quick way of checking how many child items there are by querying the sitecore master db?
8
votes
1answer
327 views
Sitecore Site using custom database on custom site
Sitecore 9.0.1
I've tried to create a new site definition that's associated with a custom publishing target database.
I have the database registered, publishing targets built, content completely ...
2
votes
1answer
678 views
Sitecore Custom Databases for user generated content
I need to store a set of information (for example, poll results, article comments, etc,).
I would like to use the Sitecore pattern to manage information (templates, items and content tree) in order ...
