Unable to restore a large production database

Application issues
1

I am unable to restore a Large database file that was created with this application.
The error GRANT CONNECT TO [LOGIN_USER] AS [dbo]
Keeps breaking the restore process. I’ve attempted to restore the database backup via sqlcmd however the the script is able to run but fails midway because of a syntax error.

Becasue of the sql file being sooo large (~38GB) it is nearly impossible to modify.
I’ve attempted to split the backup file into multiple parts using (SQLDumpSplitterv3) and even then the application fails to do that.
Is there a way that force this sql file to be executed and still ignore any potential sql syntax errors? using sqlcmd?

2

Hi chen,

Thank you for the details.

You can find more details on how to resolve the issue on the web, for example at sql - How do we tell sqlcmd to continue "on error" with next batch? - Stack Overflow

If you have any other questions related to SQLBackupAndFTP please let us know.

Thank you and sorry for the inconvenience.