Questions tagged [sql-database]

Question about the Sitecore SQL databases - content, reporting, sessions, ...

Filter by
Sorted by
Tagged with
5
votes
1answer
268 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 ...
3
votes
1answer
606 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 ...
0
votes
1answer
263 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 ...
2
votes
1answer
349 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
146 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 ...
7
votes
1answer
624 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....
5
votes
2answers
551 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
387 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).
2
votes
1answer
493 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
2answers
2k views

Max concurrent workers/Max concurrent sessions

We have 11 client Sites hosted on Azure PAAS setup with SQL on standard S2 tier. We also have planned to remove Inrole cache and Implement SQLSession Cache on these Production servers. For all 11 ...
7
votes
2answers
893 views

How can I remove / delete Sitecore database log (*.ldf) files

Is there any special procedure to clear up large log files in Sitecore databases? Our integration server has a huge (25GB) log file which I would like to dispose of, but not sure of the procedure. On ...
3
votes
2answers
248 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 ...
1
vote
2answers
463 views

Sitecore Core database User table restoration

We have upgraded the application from 7.2 to 8.2 Post restoration we were not able to connect to Sitecore admin console. For accessing executed a query to update the admin account password but somehow ...
0
votes
1answer
69 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 ...
16
votes
5answers
283 views

Publishing without SQL

What approach should I use to enable a customer to deploy content (just items) from their CM environment to a CD environment, where the CD environment would not allow any SQL ports through the ...
1
vote
0answers
70 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
172 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
84 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
470 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?
2
votes
1answer
898 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 ...
2
votes
1answer
2k views

Sitecore CMS - Timeout expired error

I have a Sitecore instance Version 8.2 Update 3 in my local PC. When the CMS or live is not visited or idle for a while and I browse it again, the page doesn't load and shows this error: Cannot ...
0
votes
1answer
201 views

SQL migration while upgrading Sitecore 8.1 to Sitecore 9 [duplicate]

I have a some instances running on Sitecore 8.1 .I want to upgrade these instances to Sitecore 9.1. I know that I should use MS-SQL-2016 to support XDB. I want to install Sitecore-9.1 directly and ...
11
votes
3answers
1k views

When is it safe to remove an `EventQueue` record?

Sitecore stores its events in a database table called EventQueue. It is used for centralized event-based communication between Sitecore instances. Sometimes this table grows quite large and it needs ...
2
votes
1answer
223 views

Getting “Could not access network location SC_SQL_SERVER_USER” while installing Sitecore using Powershell DSC

I am trying to install Sitecore using PowerShell DSC following below link https://jermdavis.wordpress.com/2015/11/09/development-environments-with-powershell-dsc-part-5/ I am getting "Could not ...
5
votes
2answers
3k views

Setting up multiple publishing targets

I have a newly setup XP1 Sitecore 9.0 environment. It has single core, master and web databases currently. I’m looking to create a new publishing target/CD server for staging/UAT. I’ve seen various ...
1
vote
2answers
367 views

SqlShardingDeploymentTool causes Sitecore 9.0 update 1 installation to fail during SIF installation

I'm trying to setup a Sitecore 9.0 update 1 installation on my local machine using windows 10 Solr 6.6.2 SQL Server 2016 SP1 Sql Express 2017 SIF-less 0.6.0.0 Despite a couple of annoying hickups I ...
3
votes
1answer
300 views

EXM databases setup - minimal rights

I am upgrading my Sitecore isntance from 9.0 initial to update-1. In this process I had to deploy the databases for EXM (exm.master and messaging) as that is new in this version. I used the dacpac's ...
4
votes
1answer
132 views

Can I restore the Recycle Bin from a backup after using the Express Migration Tool? [duplicate]

We recently discovered that our Recycle Bin no longer contained items before November 2017, when we performed a Sitecore upgrade using the Sitecore Express Migration Tool (version 2.0 at the time). ...
1
vote
1answer
248 views

Which sql database contains the item's display name?

Please help me know which sql database contains the Sitecore's item display name?
6
votes
2answers
3k views

What version of SQL Server can I use on Sitecore 9

I was wondering what version of SQL Server is best used (or allowed to be used) with Sitecore 9: SQL Web or Standard? https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-...
5
votes
0answers
748 views

Cannot insert duplicate key row in object 'dbo.Items' with unique index 'ndxID' [closed]

I am getting the error below when doing a "Republish All". I did a search in the content editor for 7fe5a598-e1c9-42c3-b250-e5b2daa42043 and only found one item. The item is marked as "locked". If ...
7
votes
1answer
224 views

Sitecore CM/CD/SQL IOPS Guidelines

When looking at whether Azure premium storage is necessary, IOPS (input/output operations per second) is a good metric/guideline to look at. Does Sitecore provide any recommendations/guidelines as to ...
5
votes
0answers
196 views

Sitecore 8.2 using analytics data in code

I have followed the answer here But I get a null reference exception if I do not create an instance of the ReportDataProvider. And when I do create an instance I am getting an error in the ...
9
votes
2answers
1k views

Performance problems with the Sitecore SQL Session Provider

Has anyone seen any performance problems with Sitecore SQL Session Provider? We are noticing some problems with blocking queries under load, specifically the GetItemExclusive stored proc.
1
vote
0answers
340 views

Amazon RDS and SQL Session State

I am setting up an environment with the databases stored on Amazon RDS. I am running into a problem with using SQL Session State. I get the YSOD with this error: Parser Error Message: Synonym '...
2
votes
1answer
2k views

Synonym 'Applications' refers to an invalid object

After adding SQL Server private sessions storage I get this error: Synonym 'Applications' refers to an invalid object Here is the relevant web.config section: <sessionState mode="Custom" ...
1
vote
1answer
592 views

how to unlock all items that were locked by virtualssuser?

How to unlock items that were locked by virtualssuser sitecore 8.1 ? query like it can't find any records about user in code database SELECT UserId FROM dbo.aspnet_Users WHERE UserName like '%...
6
votes
1answer
1k views

Unable to change DisplayName of the item

In this curious case I'm facing here, I'm unable to change any item's Display Name. I have tried changing DisplayName from Ribbon menu, from Appearance section and Sitecore Rocks. I can write new ...
3
votes
2answers
73 views

Sitecore 6.5 - Clean Up Databases option nothing happen / shows when I click on it

I've a Sitecore 6.5 installed and the databases are huge - Core & Master have 14GB each - and I was looking to get them cleaned up. After sign-in Sitecore 6.5 Desktop, here are the steps ...
2
votes
1answer
2k views

SIM => SQL Server Connection String Error: 25

I'm progressing in a Sitecore installation on a Dev laptop. SQL Server up-and-running, able to login as Sitecore / ..... to whom I gave Sysadmin. So far, OK. But the SIM connection string: Data ...
5
votes
3answers
470 views

Script to identify largest gap(s) in content entry over a period of time

One of our clients has reported an issue wherein after our most recent deployment some of their content appears to have gone missing and/or been reverted. I'm not looking for a way to find out the ...
6
votes
2answers
1k views

Bulk deleting Sitecore users

By mistake an editor created thousands of sitecore users that now need to me removed. Using the User Manager would take too long as it allows you to remove them one by one. If deleting the users by ...
12
votes
2answers
1k views

How to handle multiple Core Databases in a multi-datacenter setup on Azure PaaS

I'm wondering how to handle multiple datacenters for CD servers in Azure PaaS. According to this ( https://kb.sitecore.net/articles/610106 ) you can use transactional replication for your Web ...
5
votes
2answers
453 views

Azure PaaS Deployment Failure - Invalid column names in “web” database

I am trying to deploy Sitecore 8.2 Update 2 instance to Azure PaaS. I've installed a fresh instance on my local machine, installed content/media/template packages from our previous version, ...
2
votes
2answers
2k views

What is the recommended approach for storing custom data within Sitecore?

Our Sitecore project needs to store some custom data (results from a user poll). Is there some sort of a built-in functionality for storing that data on Sitecore sites? The obvious solution is to ...
5
votes
1answer
548 views

How Sitecore 8.2 controls the communication with SQL Server Always On?

I was reading about Sitecore using SQL Server Always On, and I saw the ConnectionStrings example <add name="master" connectionString="Data Source=*****;Initial Catalog=*****;Integrated Security=...
3
votes
1answer
171 views

ExternalUser field in Sitecore DMS Visitors table

My site is hosted in Sitecore 7.2 and we are using DMS for analytics. I tried to fetch count details based on user email who access a particular item which is restricted for one particular group. I ...
1
vote
1answer
5k views

Log4net not inserting record into database

I am using the Log4Net to insert errors into MSSQL. However, the errors are not being logged into the database. Log4net Patch File - z.Logging.config <?xml version="1.0" encoding="utf-8" ?> &...
4
votes
2answers
589 views

How content changed in ContentEditor is being displayed in website even item not published

I changed content in one field in ContentEditor and then shifted to web database. Here I could see content change is not available which is fine because I haven't yet published but when I browsed the ...