Forum Discussion

alinawaz's avatar
alinawaz
Level 5
14 years ago
Solved

Restore SQL Server Database to other Server

Hi All,

 

We have two SQL Server 2008 servers, i am trying to restore SQL Server databases to 2nd server it is working fine using SQL Redirection option but i dont want to attach those databases on 2nd server, the backup exec is attaching databases itself during restore.

i am using "use this path" option  in sql server redirect.

can i restore sql databases using "file redirect option" to 2nd server without installing SQL server on 2nd server?

 

Thanks

agha

 

 

2010
Backing Up
Backup and Recovery
Backup Exec
  • Striker_303's avatar
    Striker_303
    14 years ago


    -Create a restore job, Select the database to restore
    -click Microsoft SQL Redirection.
    -Enter the destination SQL server name(same or different)
    -leave instance blank( if restoring to same one)
    -Type in a new name for database to restore
    -Start the restore job

    Refer: Performing local and redirected restore of SQL 2000 & 2005 Databases with Backup Exec for Windows Servers (BEWS)

    http://www.symantec.com/docs/TECH56694

  • Striker_303's avatar
    Striker_303
    Level 6
    14 years ago

    No you cannot restore .mdf and .ldf file directly to a folder

    Be will need to contact SQL API to restore databases

     

    You can redirect restore SQL databases with new name on same server\instance (wihout affecting exiting online databses (same ones)

    and get .mdf and .ldf)

  • alinawaz's avatar
    alinawaz
    Level 5
    14 years ago

    Thanks,

     

    --You can redirect restore SQL databases with new name on same server\instance (wihout affecting exiting online databses (same ones)

    how can we do this, can you please explain the steps? how it will work on same instance/server?

     

    Thanks

    Agha

  • Striker_303's avatar
    Striker_303
    Level 6
    14 years ago


    -Create a restore job, Select the database to restore
    -click Microsoft SQL Redirection.
    -Enter the destination SQL server name(same or different)
    -leave instance blank( if restoring to same one)
    -Type in a new name for database to restore
    -Start the restore job

    Refer: Performing local and redirected restore of SQL 2000 & 2005 Databases with Backup Exec for Windows Servers (BEWS)

    http://www.symantec.com/docs/TECH56694

  • alinawaz's avatar
    alinawaz
    Level 5
    14 years ago

    Thanks a lot,

    i restored successfully with different database name, it is working fine.

     

    Thanks

    Agha