Re: [google-cloud-sql-discuss] SQL Server - .bak file import - "An unknown error occurred"

Hi Ausias,

As you mentioned that restore is getting failed even without starting so we can do two things here to dig down the issue.

1. Run below TSQL first to verify the backup (,bak) file.

RESTORE VERIFYONLY FROM DISK = C:\AdventureWorks.BAK
GO

2. Enable below Trace flags on session level to log more detailed information when you run the restore command.

3604,3004,3605, 3014,3213 

Regards,

Abhishek Madan 

On Thu, Nov 26, 2020 at 11:44 AM Ausias March <ausias@dribia.com> wrote:

Hi everyone,

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.

--
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/CAA1X%3Dn%3DzK%3DqY60tM3KT-KQLU7W6U4oVs%3DD_5KE12DNpV9HvNag%40mail.gmail.com.