117 votes
Accepted

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

The accepted answer is valid for previous version of Sitecore, but it does not reset the password salt and doesn't in fact reset the password to 'b'. In order to do this, you need the following ...
Derek Dysart's user avatar
  • 2,489
63 votes

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

Yes there is. Switch to your core database and execute the SQL below to reset the password to b: UPDATE [aspnet_Membership] SET Password='qOvF8m8F2IcWMvfOBjJYHmfLABc=' WHERE UserId IN (SELECT ...
Mark Cassidy's user avatar
  • 25.2k
31 votes
Accepted

How does the "Clean up databases" feature work?

In a Sitecore 8, this will: Cleanup CyclicDependences (items that couldn't be removed by CleanupOrphans because they have a parent but are not in the item tree) Cleanup InvalidLanguageData (remove ...
Gatogordo's user avatar
  • 20.1k
26 votes

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

Unlock_Admin doesn't work when you will decide to change your password encryption from SHA1 into SHA512 (regarding to Sitecore recommendations). It does NOT reset password for Sitecore admin - it just ...
Łukasz Skowroński's user avatar
22 votes
Accepted

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

A very large log file is symptomatic of the problem of no backups taking place. Under normal circumstances SQL log files get truncated on backup. It is quite normal that a CI environment gets quite ...
Mark Cassidy's user avatar
  • 25.2k
17 votes
Accepted

Mongo vs SQL Server with Sitecore 9 Update 2

1) Infrastructure MongoDB will introduce new element into infrastructure of your solution. This increases cost of servers, cost of maintenance and at the end complicates the overall solution ...
Peter Procházka's user avatar
16 votes
Accepted

Setting up multiple publishing targets

Scenario Let's say you need create a second publishing target called staging. Steps Publishing Target You need to create an item for the new database in the content tree at the path /sitecore/...
Hishaam Namooya's user avatar
15 votes
Accepted

Move users / roles / passwords to new core database

There are a few options to transfer Users and Roles from one instance to another. Sitecore Packages You can use the standard Package Designer application from the Development Tools menu in the ...
jammykam's user avatar
  • 13.8k
14 votes

How does the "Clean up databases" feature work?

Typically, a cleanup operation will remove data in invalid languages and items in orphaned trees. That means: all invalid language data (i.e. data for which the language does not exist) will be ...
Vlad Iobagiu's user avatar
  • 18.5k
13 votes
Accepted

Sitecore Azure SQL database maintenance

Yes, you definitely still need to perform regular database maintenance. Especially on Sitecore DBs like Analytics that have a lot of activity and develop index fragmentation quickly. At least, if ...
Richard Hauer's user avatar
12 votes

Publishing without SQL

Ok. Well. Would definitely be possible to set something up with Unicorn for this - albeit it a highly unusual configuration. Steps I would take would look something like this: Set up Unicorn on the ...
Mark Cassidy's user avatar
  • 25.2k
12 votes
Accepted

'sqlcmd' is not recognized at CreateShardApplicationDatabaseServerLoginSqlCmd step

Right after post my question, realized that sqlcmd was not installed at the server - which is weird, because XP1 topology didn't require at all! In my case, I had to download and install Microsoft ...
Vinicius Deschamps's user avatar
9 votes
Accepted

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

The Analytics DB is used as a reporting database for xDB. MongoDB is the collection database and periodically this is aggregated and stored in the Analytics db (also called the reporting db). If you ...
Richard Seal's user avatar
  • 20.4k
8 votes

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

Yes. You need a new <appender>. First you need to set up a table to receive the logging information: CREATE TABLE [dbo].[Log] ( [Id] [int] IDENTITY (1, 1) NOT NULL, [Date] [datetime] NOT ...
Mark Cassidy's user avatar
  • 25.2k
8 votes

Sitecore CM/CD/SQL IOPS Guidelines

I am not aware any IOPS guidelines, but there is a Sitecore Experience Platform 8.2 Performance White Paper where they have made many test and the Premium Storage Account is only mentioned for MongoDB....
Tamas Varga Sitecore's user avatar
8 votes
Accepted

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

As you mentioned Replication is required for some Sitecore databases, but SQL Azure (PaaS) does not support SQL read-write geo-replication currently just read-only(https://docs.microsoft.com/en-us/...
Tamas Varga Sitecore's user avatar
7 votes
Accepted

Server Role for SQL Server Account?

You are right, you granted to much privileges. You don't have to assign any server roles, but you should should assign db_datawriter, dbreader and public role memberships for your user to the web and ...
Bas Lijten's user avatar
  • 1,857
7 votes

SQL wait times on EventQueue

To be honest, I'm not sure if what I describe below will fix the ASYNC_NETWORK_IO issue. Seeing NETWORK_IO lets me think that the issue is more network or server related than being a real Sitecore ...
Thomas D's user avatar
  • 1,703
7 votes
Accepted

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

After having processed an event from the queue each instance updates the associated last processing timestamp (LPT) which is stored in the Properties table and has the key in the following format '...
Alexander Mogilka's user avatar
7 votes

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

To get this to work with my version of Sitecore (8.1u3) after switching hashing algorithms to SHA512, I needed to make the following small adjustment to Derek's answer. USE [sitecorecmsSitecore_Core];...
Dan Sinclair's user avatar
  • 5,395
7 votes

Which databases does Sitecore 9.0.2 need for CMS only mode?

That would be an XM environment. You require: forms, core, web and master https://doc.sitecore.net/sitecore_experience_platform/setting_up_and_maintaining/sitecore_on_azure/deploying/...
Bart Verdonck's user avatar
7 votes
Accepted

Why Xdb.Collection.Shard0, Xdb.Collection.Shard1 and Xdb.Collection.ShardMapManager databases in Sitecore 9 are not Partially Contained?

xConnect uses a change tracking functionality which requires a SQL User so it can access multiple databases. For this reason, contained database authentication cannot be used on the xDB Collection ...
Jason St-Cyr's user avatar
  • 6,781
7 votes

msdeploy.exe : Error: .Net SqlClient Data Provider: Invalid object name 'Blobs'

I was facing same issue and found that it tries to update the Blobs and other tables in XP instance i.e. YourSitecoreXP_Master DB So if the Sitecore prefix in the deploy script is wrong it tries to ...
Sandeep Pote's user avatar
6 votes

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

It's not a SQL query, but this will work even when you switch HashingAlgorithms. You can create a small console application to reset/change passwords. I based this console app on the one from Bas ...
Swimburger's user avatar
6 votes
Accepted

What is Sitecore IDTable usage?

The Sitecore 6.6 scaling guide has this to say about the IDTable: You can store persistent mappings of arbitrary keys to Sitecore IDs in the Sitecore IDTable. By default, this is only used by ...
Dmytro Shevchenko's user avatar
6 votes

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

It depends how you've set up your database. You can set the recovery model to simple to get rid of most of the log file content. Go to the database with SQL Management Studio, right click on the ...
Thomas D's user avatar
  • 1,703
6 votes

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

In order to be 100% sure that a particular event was processed by all servers, you would need to write a rather complex query. To illustrate, I've written a query to return all events processed by a ...
jrap's user avatar
  • 4,931
6 votes

Performance problems with the Sitecore SQL Session Provider

You've seen the "Optimize SQL Server Performance" section (Not Applicable to Azure SQL) at https://doc.sitecore.net/sitecore_experience_platform/setting_up__maintaining/xdb/session_state/...
G Killian's user avatar
  • 1,309
6 votes

'sqlcmd' is not recognized at CreateShardApplicationDatabaseServerLoginSqlCmd step

Thank you, Vinicius. To add to the correct answer, after downloading the two utilities from your answer, my problem was not resolved. I encountered into the same issue when running Sitecore ...
Rama Krshna Ila's user avatar
6 votes

Sitecore Custom Databases for user generated content

Yes You can add as many databases as you like. I have an admittedly very old tutorial that takes you through the steps. Having just skimmed through it, I would say it's probably still perfectly ...
Mark Cassidy's user avatar
  • 25.2k

Only top scored, non community-wiki answers of a minimum length are eligible