TO mozes direktno da uradis kroz slanje posebnih BACKUP/RESTORE query-a SQL-u.
Za sintaksu i vise detalja pogledaj:
BACKUP (Transact-SQL)
RESTORE (Transact-SQL)
PS: Imaj samo u vidu da se backup query desava u kontekstu servera, dakle ako radis backup na lokalni disk (npr u fajl c:\baza.bak), backup ce biti snimljen na disk servera, ne masine koja salje query. Isto vazi i za restore.
▪ The word 'politics' is derived from the word 'poly', meaning 'many', and the word 'ticks', meaning 'blood sucking parasites' - Larry Hardiman
▪ If the good guy gets the girl, it's rated PG; if the bad guy gets the girl, it's rated R; and if everybody gets the girl, it's rated X
▪ Illegal aliens have always been a problem in the United States. Ask any Native American
Registrovani: 106 ( dragischa, refillbros.com, dragan55, sasas, Ivan1x2, DRagoslav INFOZARADA, compoff, Kiro, staticInt, bubikaj, Yeyaa, packypfc, freesoftwareman, sucur, sinissa, Mobtel, mulaz, Milan Stojanovic, yolja624, mdeka, jericho1405, cojka80, fuzzylogic, buyjoon, dexkg, stewuss je, okno, Mrmlj, LePtep, dobrid, Tehnik, apex, Vucko 146, rafiki, Ivand, zvilin, BiiigMuzzy, Vranac, SmilieBG, xp_zexoni, Marko Enter, Daniel Mauric, combuster, dobar_decko, mguzina, genijalcina, gosha, markantz, Milan Ogrizovic, triggerns, karas, Miro35, mmm121, vooksha, gusina, stanisljevic, James, dragansky, cakalino, Rasko65, dj011, Nebojsa Milanovic, senser, asferrari, Ivek33, dadodado1, teta_lija, _Mrgud_, --SOULMaTe--, gacesai, enkkara, abyss, Fedya, deepwhite, katarinac, Crnja, cobretino, tomiotok, cmilorad, lord_celtic, sekulicB, Jbyn4e, Preeky, bvuli12, Rekla Kazala, Hitman, Proko, Milan Milosevic, s.sergio, dmn, cedjabuka, mmilenkovic, kuca8uk3, crveni_marsovac, Nedeljko, stsung, Ebu Nadija, dbaban, Pigoza, predojev, samoilb, mr_pingvin, crnibombarder, delevre, JovanT, fpedja )
SQL SERVER 2005 - backup,restore