Thursday, March 29, 2012

DB backup from command line ?

What ius the synthax to backup an SQLServer DB from the command line ?
ThanksUse the OSQL utility. Type:

OSQL h

at the command line to get a list of parameters for specifying a server, database, login, etc. You can use the OSQL utility to run a simple BACKUP command, or you can specify a batch file of SQL commands to perform your maintenance.sql

No comments:

Post a Comment