Backup da Base MSSQL com Database Publishing Wizard

Backup da Base MSSQL com Database Publishing Wizard

A Microsoft disponibiliza em sua página um wizard bem simpples para que seja feito o backup da base de dados onde com poucos click’s é possível realizar este backup .

Você pode baixar o executável em , ao executar o mesmo não será apresentada nenhuma mensagem, mas o Publishing Wizard 1.2 será descompactado em C:/Program Files (x86)/Microsoft SQL Server/90/Tools/Publishing/1.2 .

Execute o SqlPubWiz.exe e será aberta a seguinte tela :

Backup da Base MSSQL com Database Publishing Wizard

Clique em Next e, na tela seguinte em “Specify Server Information” no campo “Server” Inclua o endereço que utiliza para o acesso ao banco de dados ou o endereço IP do servidor e, na parte de autenticação marque a opção “Use SQL Authentication” , e coloque o usuário e senha de acesso ao banco de dados e clique em Next.
Backup da Base MSSQL com Database Publishing Wizard

Na Tela seguinte selecione a base sua base de dados, e caso deseje o backup de todos os objetos do banco, marque a opção “Script all objects in the selected database”, do contrario nas telas seguintes terá as opções para marcar o que especificamente deseja que seja gerado o script , e depois clique em next.
Backup da Base MSSQL com Database Publishing Wizard

Depois desta tela basta clicar em next e Finish para que seja feito o backup em texto .


Selecione o local em sua estação onde será gravado o arquivo.sql , e clique em Next .
Backup da Base MSSQL com Database Publishing Wizard

Nesta tela seguinte você terá as opções de gerar o script para “dropar” os objetos, a versão do MSSQL que os scripts serão gerados , e se serão gerados os scripts para o Schema e os dados , somente o schema ou somente os dados .
Backup da Base MSSQL com Database Publishing Wizard



Caso marque para gerar os scrits de todos os objetos da base de dados, e tenha muitos dados em determinadas tabelas , é possível que você receba a seguinte mensagem de erro :

Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.

Este erro é ocasionado por este Wizard utilizar pooling para a conexão com o banco . Caso tenha este erro sugerimos que faça o backup da base em partes , selecionando os objetos que devem ser gerado o script .

O artigo ajudou ?


I’ll right away take hold of your rss feed as I can’t in finding your email subscription link or e-newsletter service.
Do you have any? Kindly permit me understand so that I may just subscribe.


It’s appropriate time to make some plans
for the future and it is time to be happy. I’ve read this post and if I could I desire
to suggest you few interesting things or advice. Maybe you could write next articles referring to this article.

I desire to read more things about it!

hi!,I love your writing very much! percentage we keep up a correspondence extra approximately your article on AOL?

I need an expert in this space to solve my problem.

Maybe that is you! Looking forward to peer you.

Hey there! This post could not be written any better! Reading through this post reminds me of my old room mate! He always kept chatting about this. I will forward this page to him. Pretty sure he will have a good read. Thank you for sharing!

Definitely believe that which you said. Your favorite justification seemed
to be on the web the simplest thing to be aware of.

I say to you, I certainly get annoyed while people consider worries that they just do not
know about. You managed to hit the nail upon the top
and defined out the whole thing without having side-effects , people can take a signal.
Will probably be back to get more. Thanks

Superb site you have here but I was curious about if you knew of any discussion boards that cover the same topics talked about in this article? I’d really love to be a part of group where I can get comments from other experienced individuals that share the same interest. If you have any suggestions, please let me know. Appreciate it!

I’m really loving the theme/design of your website.

Do you ever run into any web browser compatibility problems?
A small number of my blog audience have complained about my site not working correctly in Explorer but looks great in Firefox.
Do you have any suggestions to help fix this problem?

Magnificent beat ! I wish to apprentice while you amend your site, how can i subscribe for a blog website? The account aided me a acceptable deal. I had been tiny bit acquainted of this your broadcast offered bright clear concept

I’m really inspired together with your writing talents as neatly as with the structure to your weblog. Is that this a paid topic or did you modify it yourself? Anyway keep up the nice quality writing, it is uncommon to look a great blog like this one nowadays..

Hi, I think your blog might be having browser compatibility issues.

When I look at your blog in Opera, it looks fine but when opening in Internet Explorer, it
has some overlapping. I just wanted to give you a quick heads up!
Other then that, very good blog!

Great items from you, man. I have bear in mind your stuff prior
to and you are simply extremely magnificent.
I actually like what you have obtained here, certainly like what you are stating
and the way in which you say it. You make it entertaining and
you continue to care for to keep it wise. I cant wait to read far more
from you. This is really a terrific website.

Deixe uma resposta