Re: 1:1 Kopie von einem SQL-Server erstellen (Test-Server einrichten)
Date: Fri, 23 Jul 2004 15:27:15 +0200
Hallo Christoph!
Habe es jetzt wie folgt gemacht:
- Windows NT inkl. Servicepack
- SQL Server 7.0 inkl. Servicepack
- master-Datenbank im single-user-mode mittels RESTORE vom Dump geladen
- SQL Server wieder "normal" gestartet
- Fehlermeldungen im Protokoll ignorieren ...
- alle Benutzer-Datenbanken mittles RESTORE (WITH REPLACE) vom Dump geladen
- fertig!
Danke für die Infos!
Gruß, Dirk.
Relevant Pages
- Re: DFSMSdss Data Loss Exposure (UPDATE)
... PATCH BYTE FOR DS1DSCHA / DS1IND20 ON FULL AND TRACKS RESTORE ... TRACKS RESTORE when DFSMSdss is not invoked via the API. ... This future enhancement would possibly include a change in default RESTORE behavior based on use of "RESET" in DUMP, with a new RESTORE option to allow for overriding default behavior. ... The crux of the problem is that the only practical way to make a physical copy of a volume with DFSMSdss for moving the volume or recovering it elsewhere is with "DUMP FULL" physical dump, and if this is recovered to another device with the obvious counterpart "RESTORE FULL", the result is currently not an identical volume, but a volume with all the VTOC "changed" bits on the volume reset. ...
(bit.listserv.ibm-main) - DFSMSdss Data Loss Exposure (Was Re: DFSMSdss DOC APAR OA20117)
... which is the default usage, indicating the dump is not intended as a replacement for individual dataset dumps -- to save the image of a DASD volume and expecting at some point to use this dump with a "RESTORE FULL" to move the volume to another DASD drive, as part of a Data Center move or migration to new equipment, or for Data Center recovery at a remote site, THEN MOST LIKELY YOU ARE CURRENTLY EXPOSED TO SOME FORM OF DATA-LOSS! ... The crux of the problem is that the only practical way to make a physical copy of a volume with DFSMSdss for moving the volume or recovering it elsewhere is with "DUMP FULL" physical dump, and if this is recovered to another device with the obvious counterpart "RESTORE FULL", the result is currently not an identical volume, but a volume with all the VTOC "changed" bits on the volume reset. ...
(bit.listserv.ibm-main) - Re: Backing Up WSS
... Backup and Restore Options for Windows SharePoint Services ... ·Use the Microsoft SQL Server 2000 tools to back up the databases. ...
(microsoft.public.sharepoint.portalserver) - Re: DFSMSdss Data Loss Exposure (UPDATE)
... APAR OA20907 was opened by IBM to provide a temporary fix to the DFSMSdss RESTORE problem in the form of ADRDSSU patch byte that can be set by an installation or on a specific invocation of ADRDSSU to inhibit the reset of the DS1DSCHA bit on "RESTORE FULL" or "RESTORE TRACKS". ... This future enhancement would possibly include a change in default RESTORE behavior based on use of "RESET" in DUMP, with a new RESTORE option to allow for overriding default behavior. ... The crux of the problem is that the only practical way to make a physical copy of a volume with DFSMSdss for moving the volume or recovering it elsewhere is with "DUMP FULL" physical dump, and if this is recovered to another device with the obvious counterpart "RESTORE FULL", the result is currently not an identical volume, but a volume with all the VTOC "changed" bits on the volume reset. ...
(bit.listserv.ibm-main) - Re: Disaster Recovery question
... Can you post the SQL Server error log of the dysfunctional server? ... > You can restore master to another box. ... > 1) Drop the suspect DB's and simply restore from backup. ...
(microsoft.public.sqlserver.server) |
|
