Problem backing up RCC 2.6

[ECartman]

Hey Guys,

Trying to backup an installation of RCC2.6 so it can be moved to a new PC.

However, when in SQL SMSE and try to connect to CCRDB to backup, I get the following error

===================================

Backup failed for Server 'RRC-PC\RCCSQLEXPR'. (Microsoft.SqlServer.Express.Smo)

------------------------------
For help, click:

http://go.microsoft.com/fwlink?Prod...xceptionText&EvtID=Backup+Server&LinkId=20476

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
at Microsoft.SqlServer.Management.SqlManagerUI.BackupPropOptions.OnRunNow(Object sender)

===================================

System.Data.SqlClient.SqlError: The server principal "backupuser" is not able to access the database "CCRDB" under the current security context. (Microsoft.SqlServer.Express.Smo)

------------------------------
For help, click:

http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)

Any thoughts really appeciated

Thanks ! ! !

 

[snowman50]

have you stopped the service first ,then do a backup