#backup database command

[dpkshr]

SQL Server – Backup database from Command Prompt using sqlcmd command

Introduction

Here, I will explain how to backup an SQL Server database from Command Prompt using sqlcmd utility

Step 1: Open Command Prompt and type sqlcmd -S localhost\SQLServer2014 -U sa , then press enter. Here localhost\SQLServer2014 is server name and sa is username.

To backup database using Windows Authentication, type sqlcmd -S localhost\SQLServer2014 –E and press enter and skip Step 2

St…

View On WordPress