I'm trying to import .bak file from google cloud storage into cloud sql and getting below error
generic::invalid_argument: execution of restore command failed with error: {mssql: RESTORE DATABASE is terminating abnormally.} Known Issue: presizeDiskForImportHelper: Error doing disk presize check with error: connection error: desc = "transport: Error while dialing dial tcp [::1]:8086: connect: connection refused"
I tried to google error but I didn't find any useful information except there is probability the backup file is bad.
Update
The database in cloud SQL is shown with Default collation
when I type
Use mydatabase
I got
Database 'mydatabase' cannot be opened. It is in the middle of a restore.
question from:
https://stackoverflow.com/questions/65872161/importing-bak-file-into-google-cloud-sql 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…