What is the closest role I could get as sysadmin on GCP sqlserver

[Zayar Wai Lin]

Hello Guys,

I am a newbie mssql database administrator. I am practicing my lessons on GCP.

I am aware that GCP doesn't support sysadmin role at sqlserver level.

What I am curious is how can I get the closest role as sysadmin on GCP?

I was trying to restored .bak from my local disk drive and its throwing me this error. Appreciate if anyone can enlighten me on this.

Cheers

Zayar.

[Aref Amiri (Cloud Platform Support)]

Hi Zayar,

The closest would be the default sqlserver user which is created at the time the Cloud SQL server is created. You can find more information on its permission here. You can also create new users with new roles by following the steps provided here.

[Sulman A.]

Hi Zayar,

Were you able to restored .bak from local disk?

Can you guide on it?

Thanks!

[Olu]

Did you see this article[1]? I think it is interesting as it explains how to import data from BAK files into Cloud SQL. 

[1]https://cloud.google.com/sql/docs/sqlserver/import-export/importing#bak

[Sulman A.]

Actually, I do read this article but getting error.

I followed the steps mentioned on it.

After selecting the [.bak] file when click on Import button got this error message attached screenshot. And error message is only showing this text [ An unknown error occurred ].

Error message contains no other details so getting difficult to debug.

[Aref Amiri (Cloud Platform Support)]

I'd suggest creating a Private Issue Tracker and provide your project ID, instance name and steps to reproduce as this requires further investigation.

[Sulman A.]

Aref thanks a lot I've created the ticket on issue tracker.