On standalone Recorder, a backup device is created which allows Recorder to backup and restore the database from a known location on the disk, called NBNData_Backup. The backup and restore functionality is disabled on the network version unless you manually create a backup device of this name, because in the network version we would recommend a scheduled backup policy is put in place rather than ad-hoc. Unfortunately, the dialog that lets you reconfigure the location of the NBNData_Backup device does not get disabled, but it probably should. I guess that's a minor tweak that should go into the next release.

So, to answer your question, just create a backup device on the SQL server called NBNData_backup.

Best Wishes

Having just reinstalled SQL Server 2005 Express and got R6 running again, I find I have lost the backup facility. Mine is a network installation but on a standalone machine, so I suspect the problem may be the absence of this device NBNData_backup. Sorry to be ignorant, but how and where do I create it?

Thanks, Charles, it's working now.

Hi Janet,

Not sure whether the following post might help - this user also had some issues with nbnuser on vista: http://forums.nbn.org.uk/viewtopic.php?id=761

Hope this helps.
Lynn

I have had this problem since a new server was installed, but I cannot create the backup device as I lack necessary permission, any idea to what I need permission?

Hi Rob
If you are connecting using the NBNUser login on SQL Server (rather than a trusted connection) then NBNUser should have the db_backupoperator role assigned to it which lets you do this. If using trusted connections then you will have to add this database role to yourself.
Best Wishes

OK John

I have checked and the db_backup operator role was already in place both for my own trusted login and for NBNUser. I am unable to restore a backup either from within Recorder or from Managment Studio.

Today it is not saying that I don't have permission, instead I get the message that the backup cannot be restored because the database is in use. It is not, as I am the only person who has used it at all today (once to attempt the restore). Last night we recieved this message a few times so tried a server restart to ensure it was not in use, but at that point we got the message about permissions.

I will have to correct the changes I was hoping to restore manually as I am currently keeping several people from their work and further server restarts will not be possible until tonight, but it is important we get to the bottom of this. Any further help would be gratefully received.

Things move on... or backwards.

After some more investigation I now realise that the change backup location dialog is in fact reporting the location correctly, from its perspective, as the backup location is on the D drive of the server, which we see as the Z drive.

I assume that the reason the dialog tells me I cannot change the backup location is because this has to be done through SQL server rather than the Recorder UI, maybe this bit of functionality is a hangover from the time before SQL server, or maybe it is possible to move the backup location on a standalone installation? Anyway I am confident now that we have the tools necessary to create backup files wherever we wish.

Which brings me back to the problem in hand. I have just successfully created a backup, there was a short pause and the datestamp on the backup file is correct, it looks like a backup was created.

However when I try to restore the backup, I am asked if I am sure, as usual and then immediately am presented with a notification that "The backup was not created as you do not have permission". Note the wording, I am not trying to create a backup, I am trying to restore from one.

Please can someone help with this?