Friday, 11 September 2009

SQL Tips

  • Using the sqlcmd Utility
  • Using sqlcmd with Scripting Variables
  • Syntax for SQL Express Backup with SQLCMD
    sqlcmd -S ServerName\SQLEXPRESS -Q "BACKUP DATABASE [DatenbankName] TO DISK='\\BackupServerName\Sharename\DatenbankName.bak' WITH NOFORMAT, INIT"
  • To backup to remote Systems the SQL Service cannot run with built-in accounts

No comments: