Copy Data to another Server

I am trying to set up a new server database for testing.

I have tried backing up the database (fbk) to try and restore it on our test server but I am getting an error. (see attached)

Were you able to solve your issue of recreating your database in a different server for testing? I have the same issue now.

I have tried backing up the database (fbk) to try and restore it on our test server but I am getting an error. (see attached)

5187.msnav.JPG

I have also tried restoring a “bak” file on the test server and connect to it using msnav client but I’m getting the same error as above.

Any assistance will be appreciated.

Looks like you don’t have the proper permissions in SQL. What groups are you a part of in SQL?