Question of the Dayhttp://sqlserver.ro/forums/17/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)Re: Remote Backuphttp://sqlserver.ro/forums/thread/7314.aspxTue, 16 Jun 2009 16:32:37 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7314ggciubuc0http://sqlserver.ro/forums/thread/7314.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=7314Incercati sa faceti script la jobul care se afla in spatele planului.<br>Re: Remote Backuphttp://sqlserver.ro/forums/thread/7313.aspxTue, 16 Jun 2009 11:16:34 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7313florinmatinca0http://sqlserver.ro/forums/thread/7313.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=7313Multumesc, asa a functionat fara probleme. <br /> <br />Se poate genera si un script pentru acel Maintenance plan ?Re: Remote Backuphttp://sqlserver.ro/forums/thread/7312.aspxTue, 16 Jun 2009 08:34:13 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7312katalyn0http://sqlserver.ro/forums/thread/7312.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=7312Din pacate nu reusesc sa postez o imagine (captura de ecran). Nu este nevoie de linked server. Pur si simplu, deschizi Management Studio si te conectezi la versiunea superioara, creezi un nou mentenance plan, "tragi" task-ul de backup, la configurarea task-ului dai NEW(CONNECTION)... de acolo ar trebui sa fie simplu.Re: Remote Backuphttp://sqlserver.ro/forums/thread/7311.aspxTue, 16 Jun 2009 07:56:44 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7311florinmatinca0http://sqlserver.ro/forums/thread/7311.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=7311Am incercat sa fac asta, dar cand vreau sa adaug serverul linked imi da eroare cu Connection Timeout ! <br /> <br />Am verificat si serviciile Sql Server merg, este setat sa accepte remote connections (ma pot conecta cu management studio), in firewall e deschis portul 1443.Re: Remote Backuphttp://sqlserver.ro/forums/thread/7310.aspxTue, 16 Jun 2009 06:43:26 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7310crestinul0http://sqlserver.ro/forums/thread/7310.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=7310Incearca sa adaugi serverul sql express ca si linked server. Apoi iti faci un job sql agent in care folsind comanda dump faci backupuri la serverul remoteRe: Remote Backuphttp://sqlserver.ro/forums/thread/7309.aspxMon, 15 Jun 2009 13:18:42 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7309katalyn0http://sqlserver.ro/forums/thread/7309.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=7309Dupa ce se creaza noua conexiune, or sa se poata selecta bazele de date.Re: Remote Backuphttp://sqlserver.ro/forums/thread/7308.aspxMon, 15 Jun 2009 12:38:51 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7308florinmatinca0http://sqlserver.ro/forums/thread/7308.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=7308Am facut deja asta, insa in interfata am doar bazele de date locale. Pe mine ma intereseaza sa lansez un backup pentru o baza de date aflata pe alt server.<BR><BR>Multumesc.Re: Remote Backuphttp://sqlserver.ro/forums/thread/7307.aspxMon, 15 Jun 2009 12:30:54 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7307ggciubuc0http://sqlserver.ro/forums/thread/7307.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=7307Banuind ca aveti cel putin versiunea 2005 ati putea sa intrati in Management Studio-&gt;Management-&gt;Maintenace Plans -&gt; creati un nou plan de mentenanta si acolo undeva aveti si componenta de backup, construiti o conexiune etc. ; mai departe wizardul te lasa sa configurezi jobul cu momentul si periodicitatea lansarii planului.<br>Re: Remote Backuphttp://sqlserver.ro/forums/thread/7306.aspxMon, 15 Jun 2009 12:22:35 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7306florinmatinca0http://sqlserver.ro/forums/thread/7306.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=7306Si cum anume s-ar putea face asa ceva ?Re: Remote Backuphttp://sqlserver.ro/forums/thread/7305.aspxMon, 15 Jun 2009 12:20:31 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7305ggciubuc0http://sqlserver.ro/forums/thread/7305.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=7305DaRemote Backuphttp://sqlserver.ro/forums/thread/7304.aspxMon, 15 Jun 2009 12:16:58 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7304florinmatinca0http://sqlserver.ro/forums/thread/7304.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=7304Salutare,<BR><BR>Ma gasesc in urmatoarea situatie : pe un server am SQL Server Express, iar pe un altul o versiune superioara de SQL Server.<BR><BR>M-ar interesa sa stiu daca este posibil sa creez un job pe al doilea server, care sa faca periodic un backup al bazei de date de pe primul server.<BR><BR>Este posibil ?<BR><BR>Multumesc.