Intrebari generalehttp://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)Re: backup sql server jobshttp://sqlserver.ro/forums/thread/7975.aspxMon, 18 Jan 2010 15:13:19 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7975ignatandrei0http://sqlserver.ro/forums/thread/7975.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7975OK... are cineva un script sa faca toate astea?<br>Multumesc,<br>Re: backup sql server jobshttp://sqlserver.ro/forums/thread/7972.aspxMon, 18 Jan 2010 11:22:51 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7972Diana0http://sqlserver.ro/forums/thread/7972.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7972In afara de bazele de date "user", ar trebui sa mai ai grija de: <br /> - bazele "system" - msdb (job-uri, maintenance plans...), master, model (daca sunt schimbari) <br /> - logins, users, acces la baze ("user mapping"). Eu le-as adauga la documentatia fiecarei baze. <br /> - daca folosesi "full text" - indecsi, cataloage. Atentie la SQL 2005 / 2008. <br />Nu as uita sa: <br /> - testez backup-urile <br /> - rulez la intervale rezonabile DBCC CHECKDB. "Rezonabile" inseamna suficient de des astfel incat sa am un backup "curat" la indemana daca se intampla. <br />http://www.amazon.com/Pro-SQL-Server-Disaster-Recovery/dp/1590599675 este o lectura buna...E in planul meu pe 2010, numai sa ma tin de el :)Re: backup sql server jobshttp://sqlserver.ro/forums/thread/7969.aspxMon, 18 Jan 2010 08:59:45 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7969muraruadrian0http://sqlserver.ro/forums/thread/7969.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7969Job-urile si&nbsp; tot ce tine de Sql Agent(alerte, Database mail, operator,..) stiu ca parca sunt stocate in msdb. Nu ar fi suficient un backup la ea?<br>In afara bazelor de date cred ca ar fi bun de 'scriptat' logins, credentials, ... eventual de vazut si maparile/permisiunile<br>backup sql server jobshttp://sqlserver.ro/forums/thread/7968.aspxMon, 18 Jan 2010 08:45:08 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7968ignatandrei0http://sqlserver.ro/forums/thread/7968.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7968Buna,<br>Care ar fi cea mai buna cale de a face backup la job-urile de Sql Server? La ce ar mai trebui facut backup daca iti crapa masina cu Sql Server , in afara de baza de date? Aveti un script?<br>