SQL Server database backup and restore-using sqlcmd

Backup

BACKUP DATABASE  to DISK = ' D:\AbpFirst.bak '

Restores

RESTORE DATABASE  from DISK = ' D:\AbpFirst.bak '

Use the sqlcmd command to add connection information: Backup

- - - Q "BACKUPDATABASEtoDISK='d:\AbpFirst.bak  '"

Restores

- - - Q "RESTOREDATABASEfromDISK='d:\AbpFirst.bak  '"

The restore command above is not a problem if you are backing up and restoring on the same SQL Server servers, but if you are restoring the backup file on another SQL Server, you will get an error. Because the path to the data file is verified when the backup is restored. At this point, we need to remap the data file and the log file using the WITH MOVE:

sqlcmd-S. \sqlexpress-E-Q "RESTORE DATABASEAbpfirst from DISK='D:\AbpFirst.bak'  withMOVE'Abpfirst'  to 'D:\MyData\AbpFirst_Data.mdf', Move'Abpfirst_log'  to 'D:\MyData\AbpFirst_log.ldf'"

If we do not know the name of the data file and the log file, you can use the following command to query:

- - - Q "RESTOREfromDISK='d:\AbpFirst.bak'"

SQL Server database backup and restore-using sqlcmd