• Our SQL production servers have now been re-engineered to use compellent backup technology. I have the backup files taken with compellent from the production server and wants to restore the files to our SQL test server. I created the scripts for the refresh below but the job runs endlessly with no failures but nothing gets done. Please help.

    Here are the scripts I am using.

    powershell -File “C:\Scripts\Compellent\NEO_DB_Dismount_Replay.ps1”

    powershell -File “C:\Scripts\Compellent\NEO_Log_Dismount_Replay.ps1”

    powershell -File “C:\Scripts\Compellent\NEO_DB_Mount_Replay.ps1”

    powershell -File “C:\Scripts\Compellent\NEO_Log_Mount_Replay.ps1”

    CREATE DATABASE PROCESSDB_CLONE

    ON

    (FILENAME = 'C:\MP\MP001\SQL\Data\processdb.mdf'),

    (FILENAME = 'C:\MP\MP001\SQL\Data\processdb_1.ndf'),

    (FILENAME = 'C:\MP\MP001\SQL\Data\processdb_2.ndf'),

    (FILENAME = 'C:\MP\MP001\SQL\Data\processdb_3.ndf'),

    (FILENAME = 'C:\MP\MP002\SQL\Logs\processdb_4.ldf'),

    (FILENAME = 'C:\MP\MP002\SQL\Logs\processdb_5.ldf')

    FOR ATTACH