backup through command prompt

• Atul DBA

  Hall of Fame

  Points: 3610

  More actions

  November 25, 2009 at 3:54 am

  #1083888

  Hi Shyam,

  You can find lots of good exampls in Books Online. Some of the URLs are :

  http://msdn.microsoft.com/en-us/library/ms162773.aspx

  http://msdn.microsoft.com/en-us/library/ms165702.aspx

  http://msdn.microsoft.com/en-us/library/ms180944.aspx

  List of all command prompt utilities:

  http://msdn.microsoft.com/en-us/library/ms162816.aspx

• nick.mcdermaid

  Hall of Fame

  Points: 3809

  More actions

  November 25, 2009 at 4:49 pm

  #1084404

  'there is no any listing of 'backup' command or 'restore' command and its parameters.so how can i get all the available commands in sqlcmd.'

  BACKUP and RESTORE commands are T-SQL commands. T-SQL is the SQL Server programming language. You'll need to go through help files etc. to learn it.

  For example if you open up SQL Server help and look up BACKUP you'll find help on its syntax.

  All of the 'available commands in SQLCMD' are exactly the same as the available commands that you use in a query window in SQL Server Management Studio.