Angemeldet Logged in as: Anmelden
Suche:
Diese Seite kann nicht editiert werden.

Migration des Datenbankservers

    Inhaltsverzeichnis
    Um zurückzugehen, müssen die aktuelle und die ältere Version mit Hilfe der Historie verglichen werden.

    Kombinierter Revisionsvergleich

    Vergleich der Version vom 10:43, 24 Mar 2016 von salbat mit der Version modifiziert am 10:57, 24 Mar 2016 von salbat.

    ...

    RESTORE DATABASE omcore

    FROM DISK= = 'C:\temp\OMCore.BAK'

    WITH MOVE 'OMCore_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\omcore_Data.MDF'',,

         MOVE 'omcore_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\OMCore_LOG.LDF'',,

    REPLACE,STATS

    RESTORE DATABASE ntadm2

    FROM DISK= = 'C:\temp\ntadm2.BAK'

    WITH MOVE 'ntadm2_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ntadm2_Data.MDF'',,

         MOVE 'ntadm2_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ntadm2_LOG.LDF'',,

    REPLACEREPLACE,,STATS

    ...

     

    RESTOREDATABASERESTORE DATABASEomcore

    FROMDISKFROM DISK = 'C:\temp\OMCore.BAK'

    WITHMOVEWITH MOVE 'OMCore_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\omcore_Data.MDF'',,

         MOVE 'omcore_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\OMCore_LOG.LDF'',,

    STATS

     

    RESTOREDATABASERESTORE DATABASEntadm2

    FROMDISKFROM DISK = 'C:\temp\ntadm2.BAK'

    WITHMOVEWITH MOVE 'ntadm2_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ntadm2_Data.MDF'',,

         MOVE 'ntadm2_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ntadm2_LOG.LDF'',,

    STATS

    ...

             

    4       Umkonfigurieren von OM-Servern auf die neue Datenbank

    ...


    4.1      Manuelle Anpassung der Registry

    ...

    5       Benutzer OMAdmin neue SID zuordnen

    ...

    6       Umbenennen eines OM-Servers

    ...

    Andere Änderungen:

    1. /body/table/tbody/tr/td/div/p/span/@style: "color:#0000ff;" ⇒ "font-family:courier new,courier,monospace;"
    2. /body/table/tbody/tr/td/div/p[2]/span/@style: "color:#0000ff;" ⇒ "font-family:courier new,courier,monospace;"
    3. /body/table/tbody/tr/td/div/p[2]/span/span[2]/@style: "color:#ff0000;" ⇒ "color: #ff0000;"
    4. /body/table/tbody/tr/td/div/p[2]/span/span[3]/@style: "color:#0000ff;" ⇒ "color: #0000ff;"
    5. /body/table/tbody/tr/td/div/p[3]/span/@style: "color:#0000ff;" ⇒ "font-family:courier new,courier,monospace;"
    6. /body/table/tbody/tr/td/div/p[4]/span/@style: "color:#0000ff;" ⇒ "font-family:courier new,courier,monospace;"
    7. /body/table/tbody/tr/td/div/p[4]/span/span[2]/@style: "color:#ff0000;" ⇒ "color: #ff0000;"
    8. /body/table/tbody/tr/td/div/p[4]/span/span[3]/@style: "color:#0000ff;" ⇒ "color: #0000ff;"
    9. /body/table[4]/tbody/tr/td/div/p/span/@style: "color:#0000ff;" ⇒ "font-family:courier new,courier,monospace;"
    10. /body/table[4]/tbody/tr/td/div/p/span/span[2]/@style: "color:#008000;" ⇒ "color: #008000;"
    11. /body/table[4]/tbody/tr/td/div/p[2]/span/@style: "color:#0000ff;" ⇒ "font-family:courier new,courier,monospace;"
    12. /body/table[4]/tbody/tr/td/div/p[2]/span/span[2]/@style: "color:#ff0000;" ⇒ "color: #ff0000;"
    13. /body/table[4]/tbody/tr/td/div/p[3]/span/@style: "color:#0000ff;" ⇒ "font-family:courier new,courier,monospace;"
    14. /body/table[4]/tbody/tr/td/div/p[3]/span/span[2]/@style: "color:#ff0000;" ⇒ "color: #ff0000;"
    15. /body/table[4]/tbody/tr/td/div/p[3]/span/span[3]/@style: "color:#0000ff;" ⇒ "color: #0000ff;"
    16. /body/table[4]/tbody/tr/td/div/p[3]/span/span[4]/@style: "color:#ff0000;" ⇒ "color: #ff0000;"
    17. /body/table[4]/tbody/tr/td/div/p[4]/span/@style: "color:#ff0000;" ⇒ "font-family:courier new,courier,monospace;"
    18. /body/table[4]/tbody/tr/td/div/p[4]/span/span[2]/@style: "color:#0000ff;" ⇒ "color: #0000ff;"
    19. /body/table[4]/tbody/tr/td/div/p[4]/span/span[3]/@style: "color:#ff0000;" ⇒ "color: #ff0000;"
    20. /body/table[4]/tbody/tr/td/div/p[4]/span/span[4]/@style: "color:#0000ff;" ⇒ "color: #0000ff;"
    21. /body/table[4]/tbody/tr/td/div/p[4]/span/span[5]/@style: "color:#ff0000;" ⇒ "color: #ff0000;"
    22. /body/table[4]/tbody/tr/td/div/p[5]/span/@style: "color:#ee82ee;" ⇒ "font-family:courier new,courier,monospace;"
    23. /body/table[4]/tbody/tr/td/div/p[5]/span/span[2]/@style: "color:#ff0000;" ⇒ "color: #ff0000;"
    24. /body/table[4]/tbody/tr/td/div/p[5]/span/span[3]/@style: "color:#008000;" ⇒ "color: #008000;"
    25. /body/table[4]/tbody/tr/td/div/p[6]/span/@style: "color:#0000ff;" ⇒ "font-family:courier new,courier,monospace;"
    26. /body/table[4]/tbody/tr/td/div/p[6]/span/span[2]/@style: "color:#008000;" ⇒ "color: #008000;"
    27. /body/table[4]/tbody/tr/td/div/p[7]/span/@style: "color:#0000ff;" ⇒ "font-family:courier new,courier,monospace;"
    28. /body/table[4]/tbody/tr/td/div/p[7]/span/span[2]/@style: "color:#ff0000;" ⇒ "color: #ff0000;"
    29. /body/table[4]/tbody/tr/td/div/p[8]/span/@style: "color:#0000ff;" ⇒ "font-family:courier new,courier,monospace;"
    30. /body/table[4]/tbody/tr/td/div/p[8]/span/span[2]/@style: "color:#ff0000;" ⇒ "color: #ff0000;"
    31. /body/table[4]/tbody/tr/td/div/p[8]/span/span[3]/@style: "color:#0000ff;" ⇒ "color: #0000ff;"
    32. /body/table[4]/tbody/tr/td/div/p[8]/span/span[4]/@style: "color:#ff0000;" ⇒ "color: #ff0000;"
    33. /body/table[4]/tbody/tr/td/div/p[9]/span/@style: "color:#ff0000;" ⇒ "font-family:courier new,courier,monospace;"
    34. /body/table[4]/tbody/tr/td/div/p[9]/span/span[2]/@style: "color:#0000ff;" ⇒ "color: #0000ff;"
    35. /body/table[4]/tbody/tr/td/div/p[9]/span/span[3]/@style: "color:#ff0000;" ⇒ "color: #ff0000;"
    36. /body/table[4]/tbody/tr/td/div/p[9]/span/span[4]/@style: "color:#0000ff;" ⇒ "color: #0000ff;"
    37. /body/table[4]/tbody/tr/td/div/p[9]/span/span[5]/@style: "color:#ff0000;" ⇒ "color: #ff0000;"
    38. /body/table[4]/tbody/tr/td/div/p[10]/span/@style: "color:#ee82ee;" ⇒ "font-family:courier new,courier,monospace;"
    39. /body/table[4]/tbody/tr/td/div/p[10]/span/span/@style: "color:#ff0000;" ⇒ "color: #ee82ee;"
    40. /body/table[4]/tbody/tr/td/div/p[10]/span/span[2]/@style: "color:#008000;" ⇒ "color: #008000;"

    Version vom 10:43, 24 Mar 2016

    Diese Revision wurde von salbat (Sperren) verändert

    ...

    RESTORE DATABASEomcore

    FROM DISK = 'C:\temp\OMCore.BAK'

    WITH MOVE 'OMCore_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\omcore_Data.MDF',

         MOVE 'omcore_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\OMCore_LOG.LDF',

    REPLACE,STATS

    RESTORE DATABASE ntadm2

    FROM DISK = 'C:\temp\ntadm2.BAK'

    WITH MOVE 'ntadm2_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ntadm2_Data.MDF',

         MOVE 'ntadm2_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ntadm2_LOG.LDF',

    REPLACE,STATS

    ...

    RESTOREDATABASE omcore

    FROMDISK = 'C:\temp\OMCore.BAK'

    WITHMOVE 'OMCore_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\omcore_Data.MDF',

         MOVE 'omcore_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\OMCore_LOG.LDF',

    STATS

     

    RESTOREDATABASE ntadm2

    FROMDISK = 'C:\temp\ntadm2.BAK'

    WITHMOVE 'ntadm2_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ntadm2_Data.MDF',

         MOVE 'ntadm2_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ntadm2_LOG.LDF',

    STATS

    ...

    4       Umkonfigurieren von OM-Servern auf die neue Datenbank

    ...


    4.1      Manuelle Anpassung der Registry

    ...

    5       Benutzer OMAdmin neue SID zuordnen

    ...

    6       Umbenennen eines OM-Servers

    ...

    Version seit 10:57, 24 Mar 2016

    Diese Revision wurde von salbat (Sperren) verändert

    ...

    RESTORE DATABASE omcore

    FROM DISK= 'C:\temp\OMCore.BAK'

    WITH MOVE 'OMCore_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\omcore_Data.MDF',

         MOVE 'omcore_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\OMCore_LOG.LDF',

    REPLACE,STATS

    RESTORE DATABASE ntadm2

    FROM DISK= 'C:\temp\ntadm2.BAK'

    WITH MOVE 'ntadm2_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ntadm2_Data.MDF',

         MOVE 'ntadm2_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ntadm2_LOG.LDF',

    REPLACE,STATS

    ...

    RESTORE DATABASEomcore

    FROM DISK = 'C:\temp\OMCore.BAK'

    WITH MOVE 'OMCore_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\omcore_Data.MDF',

         MOVE 'omcore_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\OMCore_LOG.LDF',

    STATS

     

    RESTORE DATABASEntadm2

    FROM DISK = 'C:\temp\ntadm2.BAK'

    WITH MOVE 'ntadm2_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ntadm2_Data.MDF',

         MOVE 'ntadm2_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ntadm2_LOG.LDF',

    STATS

    ...


    ...

    Unterstützt von MindTouch Core