Mind the Site Locks when Move-SPSite Fails

Recently I was working on a migration of a couple of big sites moving them to their own content databases and it didn’t exactly turn out as I planned.

So more than anything, I wanted to use this post to describe what happened and mention some tips and other things that may help others out in the future if you ever run into trouble when trying to break out sites into their own databases.

Here are the major events that happened in the migration process:

  1. Created DB under central admin
  2. Used Move-SPSite to move one site from another content database
  3. Content stuck on Move-SPSite, never finished
  4. Restarted all servers
  5. When came back up, new destination database was in recovery
  6. Recovery process used all SQL resources, major slow down of farm (sad time)
  7. Looked into SQL logs to check status of recovery thinking new destination database would come back up
  8. Actually after recovery finished, I still had no access to content created in new content database
  9. Checked and under central admin checked site locks and quotas
  10. Turns out entire site still on old source DB
  11. Hadn’t been copied over, even though SQL showed a populated database
  12. Site lock had been switched on all the way to no access
  13. Users going to site would get a 403 forbidden message when trying to access
  14. Went under site locks and cleared the lock
  15. Once this was done, content access returned to normal
  16. Original content and under Central admin still said content was on source DB
  17. New destination content DB under still showed also that it contained no content

So in the end, the big lesson learned here was that even though I could check SQL and see that the new DB contained information, SharePoint hadn’t moved the site over to the new content database.

I did some research and there are timer jobs that run gradual site deletions, but I don’t think they applied here. Either that or I switched back to the original database before anything else was allowed to happen.

In the future, I may just use Backup-SPSite  along with Restore-SPSite because that command also has the ability to specify a new database to put the site into when the backup is restored.

I hope these tips save you some time and headaches in the future.

Enjoy!

2016 Year In Review

2016 was such a great year for me professionally and personally. I had many things happen this year that were firsts for me. Longest duration on a plane, first Microsoft cert, and many others.

This year I travelled to the following places:

Orange Beach, AL

Tampa, FL

Atlanta, GA

Chicago, IL

Aurora, IL

Decatur, IL

St. Louis, MO

Phoenix, AZ

Previously I have never travelled this much in a year, so this was a big change for me. I was able to see some great places, eat some fantastic food, and enjoy and learn about a lot of new topics like Office 365 and SharePoint 2016.

This year was also the first time I had ever tried to attempt a Microsoft certification. Back in the middle of the year I tried (and failed) to pass the 70-331 exam for SharePoint 2013. I was extremely disappointed that I did not pass this test. I had prepared extensively for it and plus I’ve been working with the product in one way shape or form since it was released in 2012, for almost 5 years with two different companies.

But on a whim around the same time I signed up for the 70-339 test, I saw that Microsoft was offering a free chance to demo the exams for SharePoint 2016. Everything that I had read and studied on the product so far made me think this could go right along with what I was doing for 2013. Well… kind of…

There are some similarities and differences between the products that’s for sure. This test was different, because since it was a beta exam, I wouldn’t know my score right away.

I had a pretty good feeling about it after taking the test, but then had to wait almost two months before I found out that fortunately, I passed. 🙂

During this year I also attended a training class to prepare for the coming of SharePoint 2016 and Office 365. It was held by Critical Path Training and instructed by Matthew McDermot. This was a great course and I highly recommend it to anyone who needs SharePoint training.

I was only able to go to one SQL Saturday or SharePoint Saturday event and that was SQL Saturday Chattanooga. It was a great event, and look forward to the event next year as well.

I will definitely have to head out to more events in order to learn more with the pace that things are changing. Too bad I couldn’t travel each month to an event…hmm….

I look forward to the challenges the new year brings.

 

Here’s to a New Year!

MS Ignite 2016 Day 2

Talk, then sit. Then walk, then sit. Then walk more and sit. Rinse and repeat. 

Today was all about sessions here at MS Ignite on Day 2 and here are some of the talks that I attended during the day:

Keep your OneDrive Content Safe and Secure

Great session given on the topics of the new auditing and monitoring features coming to SharePoint on premises and Online to show how policies and other items can be created to keep users from accidentally leaking important work data to unauthorized users.

Really enjoyed the mobile device features to enable or disable apps on devices to make sure content is being shared correctly

Understand the Impact of the future of SharePoint

This roundtable session was given by 3 MVP’s to discuss what they see coming up in the future of the product and how this will affect customers. Many people shared stories from their companies in a Q and A format

Dive into Microsoft SharePoint Server 2016 Upgrade and Migration

Upgrade session given by Todd Klindt and Jason Himmelstein over the different areas of focus to keep in mind when moving to the new 2016 version. Also had great tips and tricks for people who were making the move to 2016 from either 2010 or even the 2007 version of the product.

Explore MS SharePoint Server 2016 and beyond

Great session given by Bill Baer and Troy from the product team describing bore of the new things in feature pack one coming in November along with the road map of all things SharePoint from then on. Also he mentioned that 2016 will NOT be the last on premises version of SharePoint, so it’s nice to know that we will all have something to work harder on for the next few years. 🙂

Dive into MS Office 365 and SharePoint Hybrid Scenarios

Interesting Session given by Bill and Rick laying out some of the scenarios and steps to keep in mind when going from on premises to connecting things to the cloud. Discussed things like My Sites and One Drive in the cloud along with things to keep in mind when connecting search.

Also gave several great demos on how users perspective changes once things move to online dealing with video content and Delve as well.

Learn how to build a fast, responsive SharePoint Portal in SharePoint Online

Cool session given by some of the O365 team to describe how they have gone from working with regular SharePoint on prem to O365 development practices to try and make the pages of the new SharePoint 2016 and SharePoint Online load as fast as possible with minimal overhead.

Learn about Office 365 groups and how to use them

Great short talk given to introduce the idea of Groups and the presenter gave four scenarios how users might go about using them. It was nice to see this translated into real world scenarios so this made it easier to understand

Wow that was a long day, and I will be ready to rest and go at it again for day 3.

-BJ

SharePoint Survival Course

This past week I attended a SharePoint Admin survival course and it was a great training event to learn SharePoint and everything related to it.

The main reason I wanted to attend this training was to get familiar with the new content for SharePoint 2016 and to get familiar with what it takes to implement a hybrid environment for SharePoint.

The content of this class was excellent, but the best part of the course for me was actually going through and configuring a test environment on premises and in the cloud and connecting the two. This was something in the past I wasn’t sure how to replicate and it was a great learning experience in the class.

We covered other topics like Hybrid One Drive and Sites (more like site pages), Hybrid Search in 2016, Configuring a workflow server, setting up Office Online Server (formerly Office Web Apps), and many other areas that give a good foundation to be prepared for SharePoint 2016.

There’s so many different aspects of SharePoint that could be focused on in this course, but I felt like that this had something if you are a beginner or if you have a few years (and grey hairs on you like me), there is plenty of information to be absorbed.

I would even recommend this course to those people not on 2016 yet. 2013 has plenty of presence and discussion in this course because while Microsoft has improved many areas in the newest version, the foundation of much of the product is still rooted in the functionality of 2013.

Lastly what you take away from this course is confidence. Confidence that you are better prepared for all SharePoint has to offer. You also get a great pool of scripts, links, articles and reference material that will take me a long time to digest thoroughly. If you have a chance to take this training, jump at it.

-BJ

Open SharePoint pdf in browser, not in acrobat

So I ran into a frustrating situation lately where my users when they tried to open a pdf in SharePoint, it would launch the pdf in the browser correctly, but at the same time it would open acrobat reader in the foreground with an error message.Screenshot1

This was aggravating, because I could not figure out what setting I needed to modify in order to force acrobat reader to go away without digging deep into acrobat reader.
Well turns out the solution is pretty easy to fix and has to do with an add on in IE.
To correct this issue, go under IE, then manage add ons. Then find the following add on:

Screenshot2

 

Select this add on and then choose: “Disable”

Once you do this, then close the add on window, then all your pdf’s will open in the browser window without getting acrobat blocked any more. 🙂

Hope this helps! Enjoy!

Nintex workflows not running from adding new server

This past week I had an issue of some of my Nintex workflows just not running for some reason. They would get to a certain point and just decide not to complete the next step.
Recently i added a new application server into my farm and I did not realize that in order for these workflows to run correctly they needed to have the Microsoft SharePoint Foundation Workflow Timer Service only running on the web front ends (web servers), since that is where the Nintex service actually runs.

 

So if you are running Nintex Workflow in your farm and you have a multi-tier farm for your SharePoint setup, go to central admin and check your service settings like below:

BlogPicTo be clear once more, this Should be running on your web servers if you have Nintex workflow, but should not be running on your application servers.

 

I found this out the hard way after having to contact Nintex support one day.

 

Hope this helps others,

BJ

 

SharePoint Saturday Atlanta 2015 presentation

You know how someone once said, “Better late than never?”. Well, this post would definitely fall into that category. Back on May 30, 2015 I was graciously accepted to speak at the SharePoint Saturday event in Atlanta, GA at the Georgia State University college campus.

This is a great even that the local SharePoint user group puts on each year and they always do a great job putting on an event. The title of the session I gave here was called “Camp SharePoint”. In the hour long presentation I went through various scenarios of upgrading SharePoint and the (mostly dumb) things that I have run into in my years as an admin and gave the audience some steps to follow and guidance on the pains that I have experienced in the past with upgrades and how to prepare and avoid some of those pains.
I got many questions from users who were about to get ready for a SharePoint upgrade and were curious about any things to keep an eye out for.
I had to admit, I was very, very nervous this being m first big presentation and was super excited that I was able to do this. I have been to about 5-6 SharePoint Saturday events so far, so it was great to get to experience the event from a speaker standpoint, not just from the attendee perspective. It was great getting to meet many of the speakers and folks whose webcasts and youtube videos I have watched over and over again.

For those folks who attended my session, I thank you for your time and attention and beg for your forgiveness in being late for posting the notes and slides to this presentation.

Hopefully this can be a regular thing I can begin doing in the future! I really enjoyed hearing what some of the attendees had in their own farms and some of the issues they were experiencing. If you’re on the fence about doing one of these sessions, all I can say is go for it! It will make you a better person having to prepare and give one of these sessions.

Enjoy!
Presentation Links

SPCampMap