[google-cloud-sql-discuss] Re: Importing data from a BAK file in Cloud Storage

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. :)

On Friday, September 18, 2020 at 2:56:37 AM UTC+5 Alexis (Google Cloud Support) wrote:

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

On Tuesday, September 15, 2020 at 3:50:00 PM UTC-4 sulman....@gmail.com wrote:

[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

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/9e992ed7-b38b-48cf-b594-f86aeaef0600n%40googlegroups.com.