RESTORE DATABASE Accounting
    FROM DISK = 'C:\medsys\db\bak\Accounting_backup_2012.bak'
            WITH MOVE 'V-ACCTG_DATA' TO 'C:\medsys\db\Accounting.mdf',
            MOVE 'V-ACCTG_Log' TO 'C:\medsys\db\Accounting.ldf'


           RESTORE DATABASE Billing
    FROM DISK = 'C:\medsys\db\bak\Billing_backup_2012.bak'
            WITH MOVE 'Billing_Data' TO 'C:\medsys\db\Billing.mdf',
            MOVE 'Billing_Log' TO 'C:\medsys\db\Billing.ldf'


           RESTORE DATABASE Build_File
    FROM DISK = 'C:\medsys\db\bak\Build_File_backup_2012.bak'
            WITH MOVE 'Build_File_New' TO 'C:\medsys\db\Build_File.mdf',
            MOVE 'Build_File_New_Log' TO 'C:\medsys\db\Build_File.ldf'


           RESTORE DATABASE Cardio
    FROM DISK = 'C:\medsys\db\bak\Cardio_backup_2012.bak'
            WITH MOVE 'Cardio_Data' TO 'C:\medsys\db\Cardio.mdf',
            MOVE 'Cardio_Log' TO 'C:\medsys\db\Cardio.ldf'


           RESTORE DATABASE Clinical_Area
    FROM DISK = 'C:\medsys\db\bak\Clinical_Area_backup_2012.bak'
            WITH MOVE 'Clinical_Area_Data' TO 'C:\medsys\db\Clinical_Area.mdf',
            MOVE 'Clinical_Area_Log' TO 'C:\medsys\db\Clinical_Area.ldf'

            RESTORE DATABASE Hemodialysis
    FROM DISK = 'C:\medsys\db\bak\Hemodialysis_backup_2012.bak'
            WITH MOVE 'Hemodialysis_Data' TO 'C:\medsys\db\Hemodialysist.mdf',
            MOVE 'Hemodialysis_Log' TO 'C:\medsys\db\Hemodialysis.ldf'


            RESTORE DATABASE History
    FROM DISK = 'C:\medsys\db\bak\History_backup_2012.bak'
            WITH MOVE 'History_Data' TO 'C:\medsys\db\History.mdf',
            MOVE 'History_Log' TO 'C:\medsys\db\History.ldf'
            
            
            RESTORE DATABASE Housekeeping
    FROM DISK = 'C:\medsys\db\bak\Housekeeping_backup_2012.bak'
            WITH MOVE 'Housekeeping_Data' TO 'C:\medsys\db\Housekeeping.mdf',
            MOVE 'Housekeeping_Log' TO 'C:\medsys\db\Housekeeping.ldf'
            

            RESTORE DATABASE Inventory
    FROM DISK = 'C:\medsys\db\bak\Inventory_backup_2012.bak'
            WITH MOVE 'Inventory_Data' TO 'C:\medsys\db\Inventory.mdf',
            MOVE 'Inventory_Log' TO 'C:\medsys\db\Inventory.ldf'

            RESTORE DATABASE Laboratory
    FROM DISK = 'C:\medsys\db\bak\Laboratory_backup_2012.bak'
            WITH MOVE 'Laboratory_Data' TO 'C:\medsys\db\Laboratory.mdf',
            MOVE 'Laboratory_Log' TO 'C:\medsys\db\Laboratory.ldf'

            RESTORE DATABASE Medicare
    FROM DISK = 'C:\medsys\db\bak\Medicare_backup_2012.bak'
            WITH MOVE 'Medicare_Data' TO 'C:\medsys\db\Medicare.mdf',
            MOVE 'Medicare_Log' TO 'C:\medsys\db\Medicare.ldf'

            RESTORE DATABASE MedSMS
    FROM DISK = 'C:\medsys\db\bak\MedSMS_backup_2012.bak'
            WITH MOVE 'MedSMS' TO 'C:\medsys\db\MedSMS.mdf',
            MOVE 'MedSMS_Log' TO 'C:\medsys\db\MedSMS.ldf'

            RESTORE DATABASE MSys
    FROM DISK = 'C:\medsys\db\bak\MSys_backup_2012.bak'
            WITH MOVE 'MSys' TO 'C:\medsys\db\MSys.mdf',
            MOVE 'MSys_Log' TO 'C:\medsys\db\MSys.ldf'

            RESTORE DATABASE Nuclear
    FROM DISK = 'C:\medsys\db\bak\Nuclear_backup_2012.bak'
            WITH MOVE 'Nuclear_Data' TO 'C:\medsys\db\Nuclear.mdf',
            MOVE 'Nuclear_Log' TO 'C:\medsys\db\Nuclear.ldf'

            RESTORE DATABASE Pacs
    FROM DISK = 'C:\medsys\db\bak\Pacs_backup_2012.bak'
            WITH MOVE 'Pacs_Data' TO 'C:\medsys\db\Pacs.mdf',
            MOVE 'Pacs_Log' TO 'C:\medsys\db\Pacs.ldf'

            RESTORE DATABASE Password
    FROM DISK = 'C:\medsys\db\bak\Password_backup_2012.bak'
            WITH MOVE 'Password_Data' TO 'C:\medsys\db\Password.mdf',
            MOVE 'Password_Log' TO 'C:\medsys\db\Password.ldf'

            RESTORE DATABASE Patient_Data
    FROM DISK = 'C:\medsys\db\bak\Patient_Data_backup_2012.bak'
            WITH MOVE 'Patient_Data_Data' TO 'C:\medsys\db\Patient_Data.mdf',
            MOVE 'Patient_Data_Log' TO 'C:\medsys\db\Patient_Data.ldf'
     
            RESTORE DATABASE Prepaid
    FROM DISK = 'C:\medsys\db\bak\Prepaid_backup_2012.bak'
            WITH MOVE 'Prepaid_Data' TO 'C:\medsys\db\Prepaid.mdf',
            MOVE 'Prepaid_Log' TO 'C:\medsys\db\Prepaid.ldf'

            RESTORE DATABASE Radiology
    FROM DISK = 'C:\medsys\db\bak\Radiology_backup_2012.bak'
            WITH MOVE 'Radiology_Data' TO 'C:\medsys\db\Radiology.mdf',
            MOVE 'Radiology_Log' TO 'C:\medsys\db\Radiology.ldf'

            RESTORE DATABASE Register
    FROM DISK = 'C:\medsys\db\bak\Register_backup_2012.bak'
            WITH MOVE 'Register_Data' TO 'C:\medsys\db\Register.mdf',
            MOVE 'Register_Log' TO 'C:\medsys\db\Register.ldf'

            RESTORE DATABASE Reports
    FROM DISK = 'C:\medsys\db\bak\Reports_backup_2012.bak'
            WITH MOVE 'Reports_Data' TO 'C:\medsys\db\Reports.mdf',
            MOVE 'Reports_Log' TO 'C:\medsys\db\Reports.ldf'
 
            RESTORE DATABASE Schedule
    FROM DISK = 'C:\medsys\db\bak\Schedule_backup_2012.bak'
            WITH MOVE 'Schedule_Data' TO 'C:\medsys\db\Schedule.mdf',
            MOVE 'Schedule_Log' TO 'C:\medsys\db\Scheduler.ldf'

            RESTORE DATABASE Station
    FROM DISK = 'C:\medsys\db\bak\Station_backup_2012.bak'
            WITH MOVE 'Station_Data' TO 'C:\medsys\db\Station.mdf',
            MOVE 'Station_Log' TO 'C:\medsys\db\Station.ldf'

/** OPTIONAL **/
 

           RESTORE DATABASE ASPState
    FROM DISK = 'C:\medsys\db\bak\ASPState_backup_2012.bak'
            WITH MOVE 'ASPState' TO 'C:\medsys\db\ASPState.mdf',
            MOVE 'ASPState_log' TO 'C:\medsys\db\ASPState.ldf'
            
            
            RESTORE DATABASE dbRecords
    FROM DISK = 'C:\medsys\db\bak\dbRecords_backup_2012.bak'
            WITH MOVE 'dbRecords_Data' TO 'C:\medsys\db\dbRecords.mdf',
            MOVE 'dbRecords_Log' TO 'C:\medsys\db\dbRecords.ldf'


            RESTORE DATABASE DICOM
    FROM DISK = 'C:\medsys\db\bak\DICOM_backup_2012.bak'
            WITH MOVE 'DICOM_Data' TO 'C:\medsys\db\DICOM.mdf',
            MOVE 'DICOM_Log' TO 'C:\medsys\db\DICOM.ldf'


            RESTORE DATABASE Doctors
    FROM DISK = 'C:\medsys\db\bak\Doctors_backup_2012.bak'
            WITH MOVE 'Doctors_Data' TO 'C:\medsys\db\Doctors.mdf',
            MOVE 'Doctors_Log' TO 'C:\medsys\db\Doctors.ldf'
  

            RESTORE DATABASE FixedAsset
    FROM DISK = 'C:\medsys\db\bak\FixedAsset_backup_2012.bak'
            WITH MOVE 'FixedAsset_Data' TO 'C:\medsys\db\FixedAsset.mdf',
            MOVE 'FixedAsset_Log' TO 'C:\medsys\db\FixedAsset.ldf'
 

            RESTORE DATABASE Transplant
    FROM DISK = 'C:\medsys\db\bak\Transplant_backup_2012.bak'
            WITH MOVE 'Transplant_Data' TO 'C:\medsys\db\Transplant.mdf',
            MOVE 'Transplant_Log' TO 'C:\medsys\db\Transplant.ldf'
 
 
 
            RESTORE DATABASE Transplant
    FROM DISK = 'C:\medsys\db\bak\Transplant_backup_2012.bak'
            WITH MOVE 'Transplant_Data' TO 'C:\medsys\db\Transplant.mdf',
            MOVE 'Transplant_Log' TO 'C:\medsys\db\Transplant.ldf'
 
 
 
/**
BACKUP DATABASE DICOM TO DISK =  'C:\medsys\db\bak2\DICOM.bak'  
**/