gerrate.blogg.se

Backup master database
Backup master database





backup master database backup master database

Create Blank Studiesįor each study that was on the failed system, a new study needs to be generated in Ponemah on the new system. As each study is created, the database is added to the Master database and to the Ponemah Studies database that the application can recognize. Once the new installation of Ponemah is created, blank study databases can know be created. The version of Ponemah should be the same version that the studies were created on since there can be changes to the study database format between versions. It is important to setup a new, clean installation of Ponemah to restore studies. Setup a Clean Ponemah System (done by DSI) These files will be used on the with a new installation of Ponemah to restore the Study data. Using a portable hard drive, copy all the files located in the Data folder. The sample folders below assume that SQL Server was installed on drive C:\.įor 32 bit operating system the folder is:Ĭ:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Dataįor the 64 bit operating system the folder is:Ĭ:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data Depending on the operating system being 32 bit or 64 bit, SQL Server is installed using the 32 bit components which dictates the root installation folder. This version of Ponemah uses SQL Server 2008 Express. The Status column will change from Started to display nothing.īacking up Data Folder for Ponemah 5.00 or Greater Select that line, right-click to access the menu options and select Stop. Start the Services control panel from Control Panel -> Administrative Tools -> Services. To copy all the study database files and the Ponemah application database, the SQL Server service must be turned off otherwise some of the databases will be in use and will not copy. The location of SQL Server is dependent on both the version of Ponemah and the version of the Windows operating system. Backup SQL Server Data Folder on Corrupt System (done by customer)Īll Study databases are located in the Data folder where SQL Server is installed. It is important that a new Ponemah system is setup in order to restore the studies.

backup master database

The following describes the action required to recover Studies that were created in Ponemah after a SQL Server Master database failure occurs.įailure of the master database is rare and most likely caused by a failing hard drive.







Backup master database