At "Add connection" drop-down, I selected "Connection to SharePoint Database Backup file - ready only' option, pointed to my BAK files location, (both network share and local disk). The SQL server name was automatically populated as "<SERVER_NAME>\MICROSOFT##SSEE", and the Authentication is set to "Use Current Windows user". Once I clicked connect and was returned with the following error:

I contacted Metalogix and was told it's the permission issue to sql. However, I don't have any other account besides my Windows domain admin account used to set up WSS server. I could not enable the remote connection either because this edition of SQL does not support it.
Then I used SQL server management studio express to back up the content database, then SRM seems to see the backup file but SRM crashed as soon as it started to restore.

So maybe this is not the backup solution for me till I found the workaround.
No comments:
Post a Comment