SQL Server Performance

I need to restore a sample database

Discussion in 'SQL Server 2008 General DBA Questions' started by carrascojg, Jan 6, 2010.

  1. carrascojg New Member

    I download the one wrox ssis packages
    now in this zip contrian the one SSISOps.bak FILE
    so now i want to execute in our local database how it is

    he was given the help like this

    3.) Restore database SSISOps to (local) instanace


    NOTE :

    1.) Create a folder on c: called Expert_SSIS
    2.) Extract Expert SSIS ETL.zip to c:Expert_SSIS
    3.) Restore database SSISOps to (local) instanace ????????????????????
    4.) Install the Adventure Works sample databases ?????????????????????????

    i need these 2 steps
    i want to execute the sample projects to my local system
    Anybody can help me with this?
    Thank's
  2. MohammedU New Member

    For Step4: Follow the instructions from the following link...
    http://www.codeplex.com/MSFTDBProdSamples
    For Step3: If it is a database backup file then simple you run the restore commad...
    RESTORE DATABASE <DBNAME> FROM DISK = '' OR check BOL for syntax...

Share This Page