Forum Discussion

SrikanthD1340's avatar
SrikanthD1340
Copper Contributor
Oct 17, 2024

Need help in restoring table using large .sql data file(4GB)

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...
Azure SQL Databse
Big Data
Data Warehouse
SQL
SrikanthD1340's avatar
SrikanthD1340
Copper Contributor

olafhelper 

 

Thanks for the responding. Please find below for inline comments.

1. Which tool (+version) have you used to generate the SQL script for data?

        Below screenshot for your reference.

 

2. Use a common text editor, which handle such large files like Notepad++

    we tried notepad++ but we are getting below error. Pls let me know if you have any other ideas.

  

 

rodgerkong's avatar
rodgerkong
Iron Contributor
Oct 19, 2024

SrikanthD1340 

Did you mean that SSMS has a feature can backup table to a SQL script? Interesting... Could you show the operation step by step?

 

BTW, 4G+ file can be opened with UtralEdit.

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Oct 21, 2024

    SrikanthD1340 , sorry to say, but if even Notepad++ complains about file size, then you are screwed.

     

    rodgerkong , not really a "backup", but the SSMS script wizard has the option to script data as DML commands, see

    SSMS Script objects - SQL Server Management Studio (SSMS) | Microsoft Learn => Note => "You can script the data for the database when you select Schema and data for the Types of data to script option."

     

    But at the end of the day a bad idea, there are much better options available, like BCP.

    • rodgerkong's avatar
      rodgerkong
      Iron Contributor
      Oct 21, 2024
      @olahelper got it, thank you

Resources