Questions tagged [sql-database]

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

Filter by
Sorted by
Tagged with
41
votes
5answers
20k views

Is there a way to reset Sitecore admin password from database level?

I forgot my Sitecore admin password and was thinking a way to reset from database level. Is there a SQL query to reset Sitecore admin password ?
20
votes
2answers
6k views

How does the “Clean up databases” feature work?

In the Control Panel, there is a "Clean up databases" button. How does it work? What operations are carried out during a database cleanup?
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 ...
16
votes
5answers
282 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 ...
14
votes
1answer
361 views

SQL wait times on EventQueue

Has anyone seen large wait times in SQL Server related to the Event Queue? Specifically, we are seeing ASYNC_NETWORK_IO being reported as a problem when accessing the Event Queue in SQL Server. We ...
12
votes
2answers
2k views

What is the purpose of the Analytics DB in Sitecore 8.x?

I'm migrating my Sitecore DBs from a local installation to Azure PaaS SQL instances using SSMS. I've successfully migrated Core, Master, Web and, with a small edit, Session. I'm having problems with ...
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 ...
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 ...
9
votes
1answer
506 views

Server Role for SQL Server Account?

Connecting to SQL Server I currently have set the Server Role sysadmin on the account accessing SQL Server where I'm about to host Sitecore databases. My guess is that it's way to much privileges for ...
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.
8
votes
2answers
1k 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 ...
8
votes
1answer
417 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 ...
7
votes
2answers
878 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 ...
7
votes
3answers
3k views

Sitecore Logging (Log4Net) Log to Database as Well as Text Files

Sitecore 7.5 The text file logging is working fine. But, I would like the logging to go to a SQL Server database so that I can search the data with T-SQL. How would I do that? I imagine it would be ...
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 ...
7
votes
1answer
614 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....
6
votes
3answers
3k views

'sqlcmd' is not recognized at CreateShardApplicationDatabaseServerLoginSqlCmd step

I'm trying to install Sitecore 9 Update 1 XP0 topology and everything looks great until the step CreateShardApplicationDatabaseServerLoginSqlCmd The server I am running the installation was ...
6
votes
1answer
873 views

Sitecore Azure SQL database maintenance

In this Sitecore on Azure Migration white paper http://www.slideshare.net/Jerrynott/azuremigrationwp004 It mentions on Page 17 It should be remembered that general database maintenance is still ...
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-...
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 ...
6
votes
2answers
924 views

What is Sitecore IDTable usage?

There is a table called IDTable that comes by default with Sitecore installations. What is the usage of this table ?
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 ...
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 ...
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 ...
5
votes
3answers
466 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 ...
5
votes
2answers
550 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 ...
5
votes
2answers
450 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, ...
5
votes
1answer
546 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=...
5
votes
1answer
262 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 ...
5
votes
0answers
40 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 ...
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 ...
5
votes
0answers
736 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 ...
4
votes
3answers
2k views

Configuring private sessionState database raises runtime error:

I am trying to configure a mssql private sessionState database. I added the following to web.config's : <sessionState mode="Custom" customProvider="mssql" cookieless="false" timeout="20"> ...
4
votes
1answer
182 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 ...
4
votes
1answer
342 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 ...
4
votes
1answer
130 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). ...
4
votes
2answers
585 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 ...
4
votes
1answer
653 views

Getting lots of System.ComponentModel.Win32Exception in the log

I'm getting lots and lots of System.ComponentModel.Win32Exception, Data.SqlClient.SqlException in my production CM sitecore log. Some times when use content editor or experience editor this error is ...
3
votes
2answers
245 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 ...
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 ...
3
votes
2answers
361 views

Database Server version while upgrading to Sitecore 9

I have a few Sitecore instances running on Sitecore 8.2/8.1 with databases on MS SQL 2012 and MongoDB for the xDB. I want to upgrade this instance to Sitecore 9. As I need MS SQL 2016 for the xDB I ...
3
votes
1answer
453 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?
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 ...
3
votes
1answer
597 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 ...
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 ...
3
votes
0answers
144 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 ...
2
votes
1answer
882 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
260 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 ...
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 ...
2
votes
1answer
81 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 ...