I have generated the script of my whole SQL Server database into a file and it's more than 36 GB. When I try to open it, I get the following error:
The system cannot find the file specified.
At first I intended to create the script in a new window, but every time my SQL instance got crashed. Also I have all the necessary permissions and I even tried opening it in the server, but I keep getting this error.
The server's RAM is 16 GB.
My initial goal is to change the whole database's collation (including every field and every table) and since it's a time-consuming process, I decided to generate the script of the database in order to create a new one with the right collation. I couldn't create a new window in the "Generate Script" process; therefore I had to create a new file in order to generate the script. The file is 36 GB.
When trying to open the file, I just get the mentioned error and SQL doesn't crash.