This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 24%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Hi,
We have 3 on-premise servers that we want to backup over azure.
The 2 firsts are ok, but the SQL server is giving me problems.
I'm trying to install the System Center Microsoft Azure Backup Server v3 on the SQL Server, and set up it with the existing SQL server instance, but I get the following error (see attachment).
I followed the steps of the errors I got but it never go pass that.
What am I missing ?
Thank you
I'm not familiar with DPM, so I don't know how that install wizard works. But judging from the error message you have provided a server\instance name of NO_PARAM\NO_PARAM. Or maybe NO_PARAM a placeholder for that you specified nothing at all? It's hard to say when the error message hides the UI.
(For those who don't read French: the points 1-3 are just the standards points about how correct a missing server\instance error.)
Well I know that the server is accessible over the network, maybe I don't type in the name right.
Server's name is SQL1
And database instance is MSSQLSERVER
So the error attached is when I type in : SQL1\MSSQLSERVER
I tried many other things like \SQL1\MSSQLSERVER
I'm installing the backup software on the SQL1 server so I don't understand why it's not finding it.
MSSQLSERVER is most likely not an instance name. .That is the instance id for a default instance. So you should specify the instance as SQL1 only.
Same error.
On the machine where you are running this wizard, do you have SQL Server Management Studio or SQLCMD installed? Can you connect to SQL1 from these?
I'm running this wizard on the SQL server, and yes SQL Server Management Studio is installed on it.
And the name SQL1 works from SSMS?
Sorry, I am not all familiar with this wizard. You mentioned Systen Center, so maybe you should add a tag for System Center? These tags starts with mem-. (For Microsoft Endpoint Manager.)
How do I test it out from the SSMS ?
Well actually, as it's to backup the BD from a on-prem microsoft SQL server, I went on and follow this :
https://learn.microsoft.com/en-us/azure/backup/backup-azure-microsoft-azure-backup
I can't create a new instance, cause the SQL server is already in place.
Maybe I should just do the regular azure cloud backup on this server ?
And backup the folder where my DBs are locally backed up...
How do I test it out from the SSMS ?
Well actually, as it's to backup the BD from a on-prem microsoft SQL server, I went on and follow this :
https://learn.microsoft.com/en-us/azure/backup/backup-azure-microsoft-azure-backup
I can't create a new instance, cause the SQL server is already in place.
Maybe I should just do the regular azure cloud backup on this server ?
And backup the folder where my DBs are locally backed up...
Did you see my response?!?
Yes, I'm looking into it.
How do I test it out from the SSMS ?
You try to connect to SQL Server in the normal way.
But I think Ronen's suggestion of BACKUP TO URL is a better way to go.
Hi,
We have 3 on-premise servers that we want to backup over azure.
Data Protection Manager (DPM) can do the trick but it's a bit overkilling for this task. You can simply use BACKUP TO URL. Please check the following post about backup to url and check if this fit your needs
I'm trying to install the System Center Microsoft Azure Backup Server v3 on the SQL Server, and set up it with the existing SQL server instance, but I get the following error (see attachment).
The images show errors which I cannot understand since these are not English. Please provide the exact text of the errors instead images so we will be able to translate it and maybe understand the issue
The images show errors which I cannot understand since these are not English. Please provide the exact text of the errors instead images so we will be able to translate it and maybe understand the issue
Ronen, it's the usual "Server cannot be found" stuff. The only funny thing is that the server is called NO_PARAM and so is the instance.
I'm doing it and I think it works, just wondering, I had a local backup going on, by selecting URL, does it stop the local one ?
I don't think so, but why would you be running two backups at the same time?
Ronen, it's the usual "Server cannot be found" stuff. The only funny thing is that the server is called NO_PARAM and so is the instance.
Thanks for the translation. So... I am guessing that it is in Swedish :-)
Hi,
I had a local backup going on, by selecting URL, does it stop the local one ?
No. It is just like another local backup to a different location.
With that said, unless you have good reason I would prefer to start over with a new chain of backup in the Azure (BACKUP TO URL) starting with a new full backup.
When you want to backup to multiple location then there are some approaches you can take:
(1) Take backup to one location and then copy the backup file to multiple location
(2) Take backup of the same database multiple times pointing to different locations
(3) Use "MIRROR TO" Option in the Backup command
So, the question is which approach fit your best if you want to continue having backup locally and in the Azure :-)
You should not create a simple backup to multiple location probably. You should design your backup solution according to the approach that fit your restore