I've been handed a .bak file from a Microsoft SQL Server DB. I'm trying to import it to newly created SQL Server Instance on Google Cloud. The file is 113 GB and I have stored it in a dedicated GS bucket.
The import starts but after ~15 minutes it fails with an unenlightening error message: "An unknown error occurred".
The Logs log five messages:
- spid55 DBCC TRACEON 3605, server process ID (SPID) 55. This is an informational message only; no user action is required.
- spid55 DBCC TRACEON 3014, server process ID (SPID) 55. This is an informational message only; no user action is required.
- spid55 Restore(MY_DB_NAME): RESTORE DATABASE started
- spid55 Restore(MY_DB_NAME): Opening the backup set
- spid55 Restore(MY_DB_NAME): Processing the leading metadata
But nothing about why it fails.
The storage usage increases from 0 to the 113G and drops right when it fails, which makes me believe that during that time it only copies the file.
The memory usage goes nowhere near to the instance limit.
I have tried:
- To give the instance up to 600 GB of SSD storage.
- To use the SQL Server 2017 Enterprise edition.
- Use the command line to do the import.
I would appreciate any insight anyone can give me about why this is happening and about this "An unknown error occurred" error.
Many thanks!
-- 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/c3b705be-7d3e-4f76-ab8e-f517a95241fbn%40googlegroups.com.
No comments:
Post a Comment