Not enough storage is available error when trying to open a HUGE sql file

Question

On the surface, i know this file is huge and it sounds like i'm out of hdd space. I have over 193gb available. Now here's my question. I have a .sql file that's 65gb in size. I generated it by right clicking the database and generating scripts. I included the schema and data as well.

I want to run this script so I can have a good copy of the database on my local sql server. I try to open the file in sql server management studio 2012 and i get the following error.

I cant backup the database and restore it (the preferred method) so I googled this error but I got results about everything but my issue. What do i need to change in order to open and run this ginormous file. Thanks

Answer 1

I doubt that sqlcmd will give you any better results, but here is a reference page sqlcmd

here is a sample: sqlcmd -S myServer\instanceName -i C:\myScript.sql