Should we migrate 3 TB On Premise File Server to the Cloud?

We have a 3 TB File Server which we are planning to migrate to the Sharepoint Cloud in 13 different Document Libraries.  Of the 3 TB Data: 50% files are Photoshop and Coreldraw. The rest 50% is Word, Excel, PPT, PDF & Picture files.

Post implementation – My data is going to be shared between 50 users in my office using OneDrive Sync client.

Should I consider moving ahead or not? Any tools recommended for this migrations.

Thanks, Nikunj Dalal

SharePoint On Premise – IP Range for SharePoint Store Access

I must be doing something wrong with my search for this. I’ve reached the end of the Googles and still have no answer.

I have a SharePoint 2019 farm on prem that has no Internet access by default. I need the IP ranges to create an exception for the SP Farm to reach the SharePoint Store.

I have test farm that I’ve been using to trace IP requests when I click on the SharePoint store option from within SharePoint. The IP it’s connecting to is That can’t be the only one….

I’ve looked at the Microsoft O365 IP documents but it doesn’t mention the SharePoint store explicitly and, I cannot find any mention of network 52 that I’ve observed with my test farm.

Does anyone know what the IPs for this? InfoSec won’t budge until I can locate documentation specific to the SharePoint Store connection.

Sharepoint 2013 On Premise – Break inheritance on a secondary wiki pages library

I’m working in the support team for SHP 2013 On Premise and I’m a bit stuck on an issue that a user raised. I didn’t find anywhere exactly the same topic, so in case I missed it, I’m sorry for posting this again.

The structure of the site collection is: – parent site (used by multiple departments) – sub-site (with unique autorisations to only one department) – in the sub-site above there are 2 wiki pages libraries: one should inherit the same autorisations as the sub-site, the other one should have unique permissions.

When trying to break inheritance on the 2nd wiki pages library it works, but whatever group I delete or add to the library autorisations, it’s mirroring in the sub-site autorisations too, as if the break inheritance feature didn’t work.

Now I’m currently giving unique autorisations per each page in the 2nd library, individually, but it is a bit of a struggle because it’s not 1-2 pages, there are a lot of them. Is there an easier way of doing this?

Any idea would be great! Thank you!

Backup a database from Azure SQL Managed Instance and restore to on premise SQL Server

I have three databases that I am migrating to Azure SQL Managed Instance. One is a Utility database, just a small collection of generic functions and procedures. One is the OLTP database for a web application. The third is a read-only archive of the OLTP database containing historic data for analysis and reporting as well as audit tables. I need to be able to restore these databases to on premise development and test servers. So far, I have been unsuccessful.

My first attempt was to use backup to Azure Blob Storage. But no matter what version of SQL Server I use locally, I always get an error that the Copy Only backup is from a newer version and restore is not supported.

Next, I tried Export Data tier application from SSMS v.18.1. Unfortunately, it never gets past the export. I get dozens of errors that read External references are not supported when creating a package from this platform. One of the greatest strengths of Managed Instance over Azure SQL DB is the ability to do cross-database queries. I have a number of views and procedures that link tables in the two databases. Additionally, some procedures in the OLTP database call the functions in the Utility database. Since MI is not Azure SQL database, you would think this wouldn’t be a problem!

Searching Google, I found this question on Stack Overflow. So I tried the Visual Studio approach proposed as an answer. Although it appears to work, meaning it creates a multi-gigabyte file on my local machine, attempting to import that file using SSMS gives me an error that reads No data is present in this file. So then I tried the second possible solution using sqlpackage.exe. But that solution doesn’t work for me either as it only references exporting the schema. And if I try to export the whole database with /Action:Export I get the same error message as SSMS gives.

I also examined this Database Administrators question. No help – that is what I originally attempted. If anyone has any other thoughts I would greatly appreciate hearing them!

Sharepoint on premise server 2016-Open documents in online mode

I am using sharepoint on premise server 2016.I want to open files in online mode(browser) but while opening all files are getting downloaded.I want to implement this feature to edit documents online.I haven’t activated ‘Open Documents in Client Applications by Default’ feature too.But still it is opening in my local application.How to open files in browser mode to edit it?

SharePoint 2019 theme on premise

I wish to add a theme to a SharePoint site, that is hosted on a SharePoint 2019 Server on premise.

I have followed theese instructions =>

But this seems to work only for SharePoint Online and not for SharePoint 2019 on premise.

Does anyone know how to achieve this?

Sharepoint on premise 2016

I want to develop dashboard on Sharepoint on premise 2016 which will have list to display count of approved documents,count of uploaded documents and other counts.I have separate lists of approved documents,uploaded documents,feedback documents.I want count of those in other list as per login.I am trying to do it through c# code.Is there any other option to do same or to sync Sharepoint on premise 2016 with sql server?

Moving On Premise Infrastructure into Azure/AWS

I am new to Server Fault (coming from StackOverflow) and please tell me if this is not the right place to ask this general question. Basically our company is trying to move away from an on premise infrastructure to a cloud infrastructure. We are considering Azure/Aws for this.

Currently we have some virtual machines running on our local server. A Server with the Domain Controller, a File Server, a Database Server, and one for our websites with IIS installed. Our Exchange we already moved to Exchange online with Office365 and Azure Active Directory,

However, we also wanted to move the other servers into the cloud. I thought that we can create Virtual Machines on Azure for example and join all of them to the same Active Directory by connecting them to the same Virtual Network. Would this even be the right approach?

Now, saying that we would set up everything like this, if I informed my self correctly, we would need to set up a site-to-site connection so that we can access everything on these servers from our on premise network. But is it even possible to join the Active Directory that is running on a Domain Controller on a Virtual Machine in Azure from our on premise network?

Another question, how is the performance? Of course it will be slower than having everything in house, but our files are not super large and the requests aren’t too many.

Once again, I am net to this stack exchange and I am mainly a programmer. We are a small company though and I am trying to modernize our infrastructure a little bit. I am not an expert in networking, therefore I am asking you experts here hoping to gain some knowledge. So please be nice:)!