http://sqlserver.ro/forums/14/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/5793.aspxMon, 13 Oct 2008 11:27:57 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:5793ignatandrei0http://sqlserver.ro/forums/thread/5793.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=5793<BLOCKQUOTE><div><img src="http://sqlserver.ro/Themes/default/images/icon-quote.gif"> <strong>ggciubuc:</strong></div><div><p><BLOCKQUOTE><div><img src="http://sqlserver.ro/Themes/default/images/icon-quote.gif"> <strong>ignatandrei:</strong></div><div>Eu as opta pentru script, pentru ca il modifici (mult mai ) usor decit un maintenance plan.<br>Dar probabil ca sunt mai de moda veche ....<br></div></BLOCKQUOTE></p> <p>uite cum urla programatoru' din tine :)</p></div></BLOCKQUOTE><br>Ai dreptate <img src="http://sqlserver.ro/emoticons/emotion-2.gif" alt="Big Smile" /> . Tu ai face-o, probabil, din maintenance plan ...<br>http://sqlserver.ro/forums/thread/5791.aspxMon, 13 Oct 2008 10:49:53 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:5791ggciubuc0http://sqlserver.ro/forums/thread/5791.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=5791<P><BLOCKQUOTE><div><img src="http://sqlserver.ro/Themes/default/images/icon-quote.gif"> <strong>ignatandrei:</strong></div><div>Eu as opta pentru script, pentru ca il modifici (mult mai ) usor decit un maintenance plan.<BR>Dar probabil ca sunt mai de moda veche ....<BR></div></BLOCKQUOTE></P> <P>uite cum urla programatoru' din tine :)</P>http://sqlserver.ro/forums/thread/5789.aspxMon, 13 Oct 2008 09:04:55 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:5789ignatandrei0http://sqlserver.ro/forums/thread/5789.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=5789<BLOCKQUOTE><div><img src="http://sqlserver.ro/Themes/default/images/icon-quote.gif"> <strong>Abadon83:</strong></div><div>care ar fii cea mai buna varianta ?<br>1.maintenance plan<br>2.script<br>?<br></div></BLOCKQUOTE><br>Eu as opta pentru script, pentru ca il modifici (mult mai ) usor decit un maintenance plan.<br>Dar probabil ca sunt mai de moda veche ....<br>http://sqlserver.ro/forums/thread/5787.aspxMon, 13 Oct 2008 06:13:23 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:5787ggciubuc0http://sqlserver.ro/forums/thread/5787.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=5787Eu sunt de parere ca daca tot exista wizard care&nbsp; indruma merita sa fie folosit; in plus mai sunt si alte operatii de intretinere (referitoare la indecsi, shrink etc) care pot fi lansate.http://sqlserver.ro/forums/thread/5786.aspxMon, 13 Oct 2008 06:04:51 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:5786Abadon830http://sqlserver.ro/forums/thread/5786.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=5786care ar fii cea mai buna varianta ?<br>1.maintenance plan<br>2.script<br>?<br>http://sqlserver.ro/forums/thread/5785.aspxMon, 13 Oct 2008 05:58:56 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:5785Diana0http://sqlserver.ro/forums/thread/5785.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=5785Vezi si BOL ---&gt; SQL Server Database Engine ---&gt; <SPAN id=nsrTitle>Administering the Database Engine</SPAN>&nbsp;---&gt;&nbsp;<SPAN id=nsrTitle>Automating Administrative Tasks</SPAN>http://sqlserver.ro/forums/thread/5784.aspxMon, 13 Oct 2008 05:54:28 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:5784ggciubuc0http://sqlserver.ro/forums/thread/5784.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=5784Iata si un tutorial gasit repede pe google : <A href="http://www.exforsys.com/tutorials/sql-server-2005/sql-server-2005-maintenance-plan-using-wizard.html">http://www.exforsys.com/tutorials/sql-server-2005/sql-server-2005-maintenance-plan-using-wizard.html</A>http://sqlserver.ro/forums/thread/5783.aspxMon, 13 Oct 2008 05:49:22 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:5783ggciubuc0http://sqlserver.ro/forums/thread/5783.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=5783In Management Studio intrati pe Management-&gt;Maintenance Plan-&gt;click dreapta si "New Maintenance Plan" : veti intra intr-un wizard care va conduce in final la setarea unui astfel de plan ce este lansat de un job pe care i-l puteti planifica la orele dorite;http://sqlserver.ro/forums/thread/5782.aspxMon, 13 Oct 2008 05:42:35 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:5782Abadon830http://sqlserver.ro/forums/thread/5782.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=5782vreau sa fac un backup autamat zilnic la baza de date<br>ce sugestii ar fii si daca se poate ceva tutorial<br>Ms mult.<br>