CODEWITHSUNDEEP
sql-serverssms
TomTom
TomTom

Reputation: 91

How to execute large sql file (800MB) with SSMS 2019? My sql file is database backup

I done database backup from remote server. Here i find instructions

How can I backup a remote SQL Server database to a local drive?

Now i can not open and execute file in SSMS because this file is too big.

I find examples how execute with CMD. But here you must to write database destination. And my sql script creates a new database.

sqlcmd -S myServer\instanceName -i C:\myScript.sql

Conclusion: I do not know how to execute properly my sql file.

Upvotes: 1

Views: 298

Answers (1)

TomTom
TomTom

Reputation: 91

I used just myServer. Without db name

sqlcmd -S myServer -i C:\myScript.sql

Upvotes: 1

Related Questions