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 http://go.microsoft.com/fwlink/?LinkId=119368 , 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 :
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.
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.
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 .
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 .
Observações
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 .
Your collection is both revelatory and entertaining A rare find.
This is top-notch writing You’ve earned a fresh follower.
I’m impressed with your perspicaciousness of knowledge and writing skill installmentloanskov.com/.
Don’t be afraid of USUN starting over And don’t care about anyone’s eyes As long as we breathe.
pathophysiology of heart disease an introduction to cardiovascular medicine reddit
Heya i’m for the first time here. I came across this board and
I find It really useful & it helped me out much. I hope to give something back and help others like you aided me.
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.
Thanks.
Appreciate the recommendation. Let me try it
out.
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!
Incredible story there. What occurred after? Take care!
Howdy! Would you mind if I share your blog with my myspace group? There’s a lot of people that I think would really appreciate your content. Please let me know. Cheers
Great delivery. Solid arguments. Keep up the good work.
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.
Hi! Do you know if they make any plugins to
safeguard against hackers? I’m kinda paranoid about losing everything I’ve worked hard on. Any suggestions?
Hi! I just wanted to ask if you ever have any problems with hackers? My last blog (wordpress) was hacked and I ended up losing many months of hard work due to no back up. Do you have any solutions to stop hackers?
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
My partner and I stumbled over here by a different page and thought I might check things out. I like what I see so now i’m following you. Look forward to exploring your web page for a second time.
Everyone loves what you guys are up too.
This type of clever work and coverage! Keep up the wonderful works guys
I’ve included you guys to my blogroll.
Take your trading skills to the next level and start earning up to $5000 a day.
The more you make, the more we both gain.Mirror Trading
I am not sure where you are getting your information, but great topic. I needs to spend some time learning much more or understanding more. Thanks for fantastic information I was looking for this information for my mission.
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?
I’m not sure why but this site is loading very slow for me. Is anyone else having this problem or is it a problem on my end? I’ll check back later and see if the problem still exists.
It’s difficult to find experienced people about this subject, but you sound like you know what you’re talking about! Thanks
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
Hi to all, how is all, I think every one is getting more from this web site, and your views are pleasant in favor of new people.
I really like reading a post that can make people think. Also, thank you
for allowing for me to comment!
порно мультики
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..
I do trust all the ideas you’ve introduced to your post.
They’re really convincing and can certainly work. Still, the posts are too brief for newbies.
May just you please prolong them a bit from next time?
Thank you for the post.
Wonderful blog! I found it while surfing around on Yahoo News.
Do you have any suggestions on how to get listed in Yahoo News?
I’ve been trying for a while but I never seem to get there!
Appreciate it
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.
I am genuinely thankful to the owner of this web site who has shared this wonderful paragraph at at this place.