Welcome to Sign in | Help

Re: Restore Database from Developer to Express

  •  10-01-2007, 9:15 AM

    Re: Restore Database from Developer to Express

    Da cam alambicata explicatia

    1.Masina cu SQL Server Developer Edition
    -fac backup  full la data X in fisier bac.bak
    -fac backup  full la data X+1 in fisier bac.bak
    -fac backup  full la data X+2 in fisier bac.bak

    2.Masina Vista cu SQL Express instalat cu Visual Studio
    -In promptul SQL din Servers din Visual dau "Restore Database xxx from disk =...bac.bak' with replace " . Obtin starea bazei de date la data X.Deci nu ultima care X+2... De ce?

    3.Masina cu SQL Server Developer Edition
    -fac backup  full la data X+2 in fisier nou nou.bak

    4.Masina Vista cu SQL Express instalat cu Visual Studio
    -In promptul SQL din Servers din Visual dau "Restore Database xxx from disk =...nou.bak' with replace " . Imi da statement timeout, in Visual am gasit usor cum se modifica connection timeout dar nu si asta (fara help si net).

    5.Masina Vista cu SQL Express instalat cu Visual Studio
    Fac un programel C# care executa comanda la care pot manipula usor timeout, care clar il dau baban. Si da acuma merge.

    Mentiuni
    Nu am reusit de pe masina cu SQL Developer Edition, cu Management Studio sa ma conectez la SQL Express (repede si usor desi am facut toti pasii), si pe Vista nu era instalat Management Studio...

    Intrebari
    De ce am capatat backup la data X?
    Si daca puteam  face mai elegant tot?
    Si conectarea remote la SQL pus pe Vista are cumva ceva pasi in plus fata de "normal"?

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems