Importing data from a BAK file in Cloud Storage

[Sulman A.]

[An unknown error occurred] message during import [.bak] file

I was able to import SQL Server db by Importing data from SQL files into Cloud SQL but that was time consuming because [.sql] files contain insert statements and it took time.

Now I'm trying to import a [.bak] but getting this message [An unknown error occurred] no other details? 

Before I was getting these errors while trying to import [.bak] file which I've resolved.

1) Multiple databases detected in BAK file. Only importing a single database is supported.

2) 80 is not a supported compatibility level. Supported: [140, 130, 120, 110, 100]

But now error message is [An unknown error occurred] with no other details?

I'm following this documentation:

https://cloud.google.com/sql/docs/sqlserver/import-export/importing#importing_data_from_a_bak_file_in

[Alexis (Google Cloud Support)]

Hello,

I will try to assist the best I can. 

I investigated internally and noticed that Google has had a few cases with this error and it appears that it may be due to a limitation issue in product versions. Even though the error is not very descriptive, one of these[1] limits may be causing the issue with the delta between your environment and ours. It's a vague error and hard to tell, but ensuring these limitations should be our first step, especially if it worked before.

Please check the version/features your are exporting[1] and importing from. For the import, it's here[2] under "database version" (to see which one you have in GCP).

Let us know if this helps.

[1] https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-2017#Cross-BoxScaleLimits

[2] https://cloud.google.com/sql/docs/sqlserver/instance-settings?_ga=2.151003833.-1442300237.1583515247#settings-sqlserver

[Sulman A.]

Hi Alexis,

Google Cloud SQL Database version is "SQL Server 2017 Standard"

Below are attached screenshots of SQL Servers which I'm using to create `.bak` file.

I don't know about these limits.

Thanks for the reply. :)

[Sulman A.]

Hi Alexis,

Can you just mention which SQL Server should I use to export/create .bak file which can be easily imported on  Google Cloud SQL Database version "SQL Server 2017 Standard" ?

Thanks!

[alfio]

Hello, 

Theoritically, all SQL Servers that have the ability to export database to a .bak file are compatbile with the Google Cloud SQL Database. The important thing to note, which is stipulated in the documentation you previously linked [1], is that you cannot import a database that was exported from a higher version or edition of SQL Server or import from a higher compatibility level into a lower one. Cloud SQL also only supports importing a full backup with a single backup set. Given the screenshots that you posted, I am unable to determine which one would best work for your current use case. If I misunderstood in any way or if you have any other questions, please feel free to let us know.

Kind Regards,

Alfio.

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

[Sulman A.]

Hi Alfio,

Issue is resolved now. I think it was space issue. 

I created new instance with higher space and then import the .bak file it got imported successfully.

I'm little confuse that was it space issue or was it instance issue.

It's working now.

Thanks!