Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. @Echo Off
  2.  
  3. "C:Program Files (x86)Microsoft SQL ServerClient SDKODBC110ToolsBinnSqlCmd.exe" -S SERVERINSTANCE -i "C:ScriptsFullBackup.sql"
  4.  
  5. exec spBackupDatabases '\BackupServerBackupDatabaseServer', 'F';
  6.  
  7. C:Program Files (x86)Microsoft SQL ServerClient SDKODBC110ToolsBinn>scriptsFullBackup.cmd
  8. Msg 229, Level 14, State 5, Server SERVERINSTANCE, Procedure spBackupDatabases, Line 1
  9. The EXECUTE permission was denied on the object 'spBackupDatabases', database 'master', schema 'dbo'.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement