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

Question

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

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.

Use `master` as your connection db then. – Thom A Aug 22 '19 at 07:45 — Thom A, Aug 22 '19 at 07:45
I used just myServer. Without db name – TomTom Aug 22 '19 at 11:35 — TomTom, Aug 22 '19 at 11:35

score 1 · Answer 1 · answered Aug 22 '19 at 11:36

1

I used just myServer. Without db name

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

answered Aug 22 '19 at 11:36

TomTom

1 Answers1