We have run into a situation where we need to restore the data into a SQL table. We have taken backup of data only using MS SQL Server and the .sql file size is 4 GB. Since we are unable to open this file in SQL server, we are using sqlcmd to execute this file but after restoring 140K records it is throwing some syntax error (Unclosed quotation mark after the character strig ‘abc_121223354565 and incorrect syntax near ‘abc_121223354565 ). The .sql file has total 240K records in it.

Questions:

1. When the backup was provided by SQL server only, why it is throwing syntax error?

2. How to open this large file to fix the syntax error?

if option 2 is not possible, how do we split the large file into smaller chunks so we can identify the exact place where the issue is?

Thanks,

Srikanth

​We have run into a situation where we need to restore the data into a SQL table. We have taken backup of data only using MS SQL Server and the .sql file size is 4 GB. Since we are unable to open this file in SQL server, we are using sqlcmd to execute this file but after restoring 140K records it is throwing some syntax error (Unclosed quotation mark after the character strig ‘abc_121223354565 and incorrect syntax near ‘abc_121223354565 ). The .sql file has total 240K records in it. Questions:1. When the backup was provided by SQL server only, why it is throwing syntax error?2. How to open this large file to fix the syntax error? if option 2 is not possible, how do we split the large file into smaller chunks so we can identify the exact place where the issue is? Thanks,Srikanth   Read More

​