{"id":757,"date":"2019-03-21T12:00:53","date_gmt":"2019-03-21T15:00:53","guid":{"rendered":"http:\/\/www.bfnetworks.com.br\/?p=757"},"modified":"2022-07-15T10:18:21","modified_gmt":"2022-07-15T13:18:21","slug":"sqlcmd-backup-banco-sql-server","status":"publish","type":"post","link":"https:\/\/bfnetworks.com.br\/sqlcmd-backup-banco-sql-server\/","title":{"rendered":"COMANDO SQLCMD &#8211; BACKUP DE BANCO SQL SERVER"},"content":{"rendered":"\n<p>Com o comando abaixo pode-se fazer o backup de um banco sql server windows, verifique os campos de acordo com seu cen\u00e1rio:<\/p>\n\n\n<div class=\"showyourterms dark noanimate nostatusbar\">\n<div class=\"command\" data-action=\"command\" data-delay=\"10000\" data-speed=\"100\">sqlcmd&nbsp;-S&nbsp;&nbsp;HOSTNAME\\SQLEXPRESS&nbsp;&nbsp;-U&nbsp;user&nbsp;-P&nbsp;passwd&nbsp;-Q&nbsp;&#8220;BACKUP&nbsp;DATABASE&nbsp;[NAMEBANCO]&nbsp;TO&nbsp;&nbsp;DISK&nbsp;=&nbsp;N&#8217;c:\\backup\\filebackup.bkp'&#8221;<\/div>   <\/div>\n\n\n<ul><li>-S: [protocol:]server[ \\ instance_name][ , port]<ul><li>Em cen\u00e1rios simples especifique [server_name\\ instance_name] no meu caso ficou HOSTNAME\\SQLEXPRESS<\/li><\/ul><\/li><li>-U: usu\u00e1rio para acessar banco<\/li><li>-P: senha do banco<\/li><li>-Q:  executa consulta sql (cmdline query)<\/li><\/ul>\n\n\n<h3>SCRIPT<\/h3>\n\n\n<p>Abaixo um script powershell que pode servir para fazer backup de algum banco:<\/p>\n\n\n<pre class=\"wp-block-code\"><code>$data = Get-Date -uformat \u201c%Y%m%d-%H%M\u201d    # gera data: AnoM\u00easDia-HoraMin\n$server = 'HOSTNAME\\SQLEXPRESS'\n$user = 'sa'\n$passwd = \"SuaSenha\"\n$bakfile = \"E:\\backup\\NAME_BANCO_$($data).bak\"  #caminho onde salvar\u00e1 bkp\nsqlcmd -S $server -U $user -P $passwd -Q \"BACKUP DATABASE [NAME_BANCO] TO  DISK = N'$bakfile'\"<\/code><\/pre>\n\n\n<h3>FONTES<\/h3>\n\n\n<p>https:\/\/docs.microsoft.com\/en-us\/powershell\/module\/microsoft.powershell.utility\/get-date?view=powershell-6<\/p>\n\n\n<p>https:\/\/docs.microsoft.com\/pt-br\/sql\/tools\/sqlcmd-utility?view=sql-server-2017 <\/p>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Com o comando abaixo pode-se fazer o backup de um banco sql server windows, verifique os campos de acordo com seu cen\u00e1rio: -S: [protocol:]server[ \\ instance_name][ , port] Em cen\u00e1rios simples especifique [server_name\\ instance_name] no meu caso ficou HOSTNAME\\SQLEXPRESS -U: usu\u00e1rio para acessar banco -P: senha do banco -Q: executa consulta sql (cmdline query) SCRIPT [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[5,26,10],"tags":[34,46,128,134],"_links":{"self":[{"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/posts\/757"}],"collection":[{"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/comments?post=757"}],"version-history":[{"count":1,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/posts\/757\/revisions"}],"predecessor-version":[{"id":1872,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/posts\/757\/revisions\/1872"}],"wp:attachment":[{"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/media?parent=757"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/categories?post=757"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/tags?post=757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}