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?
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 ...
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 ...
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 ...
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....
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 ...
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 ...