CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.

I am big fan of database, especially SQL server. There is no UI, no HTML, no scripts, no OOPS code. Only data and you have to play with that data.
 

I took backups of our production Sitecore master and web database and trying to restored them on QA environment.

I have done this backup and restore work 100 of times in my life. But this time I tried for 5 times and received below error during restore process –

System.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.

Solution:

I come to know that - Our database file size is more than 10 GB and QA SQL server is of type of SQL Express Edition which does not support file size more than 10 GB. 

How to know what’s the type of SQL server?

1.    Right click on server instance-> choose Properties-> Check Product entry in Server Properties window as shown in below diagram

2.    You can also get the same information by using query "SELECT @@VERSION" as follows

How to restore this 10 GB Sitecore database files?

          1. You can shrink the database files

          2. Restore databases on Standard Edition SQL Server. [I prefer this approach]

Please leave your comments or share this info if it’s useful for you.

Roles required for creating editor and reviewer role in Sitecore

I have to make editor and Reviewer for workflow. What are the different roles required for creating these roles.

I didn't get any suitable answer on Google. However after discussion with Sitecore folks, I come up with below list.

For creating Editor Group you need below roles

·         sitecore\Designer

·         sitecore\Sitecore client authoring

·         sitecore\Author

For creating Reviewer Group, you need all editor roles + Sitecore Client Publishing roles as below

·         sitecore\Designer

·         sitecore\Sitecore client authoring

·         sitecore\Author

·         sitecore\Sitecore Client Publishing

Hope this help someone while working on Sitecore workflow.

Please leave your comments or share this info if it’s useful for you.

Solved : Unable to see any items in Sitecore workbox

I was working on Sitecore workflow task. Certainly one of the newly client-side reviewer started complaining that he is unable to see items in his workbox?

I started investigation on this but unable to find any clue that why items are not visible to that particular reviewer?

For the time being I provided him admin rights and try to login from his account. Now he is able to view items in workflow approval section.

But reviewer can’t become admin. So where was the actual problem?

Solution:

If you are unable to see any item in workbox, but at the same time admin can view the items in workbox it means you don’t have permissions on items.

Assign read/write permissions from Access Viewer -> Assign Security Rights to that user/reviewer on all required items.

 

If any user can’t take any action on content tree items then Sitecore not shows any of those items in workbox as well.

Hope this pointer will help somebody who is in similar situation.

Please leave your comments or share this trick if it’s useful for you.