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