Back up Exec 10.0 restore an SQL Server 2000 DB to a redirected location

Posted on 2006-03-22
Last Modified: 2010-04-03
I am trying to restore a DB from tape to a new Database that i created in SQL Server.  We basically want to restore the database with out overwriting the current data in the DB now.  Please Help!!!
Question by:QDS
    LVL 9

    Accepted Solution

    If you have created a new database on a seperate server then there will be no data to overwrite.  I am assuming you have the following scenario:

    1. Backup of Database A, including system and master tables
    2. Created Database B on same SQL server
    3. Restore of Database A content into Database B.

    THe best way is to restore transaction logs, table definitions and system files onto a blank area of the disk as flat files and then use the import function of SQL (you don't mention the version). If the database is a simple structure I'd be inclined to manually create the tables and then simply import the data from the restore.

    I believe if you use the SQL agent to backup then restoring it will restore back to the same Database name. But you can restore to a different server name.

    Alternative method would be create a virtual or new server (maybe using MS Virtual Server) to create a completely blank SQL database and restore to this to avoid any possible corruption of Database A.

    Hope this helps
    LVL 30

    Expert Comment

    by:Duncan Meyers
    Use the redirect option in the restore options screen.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Title # Comments Views Activity
    Best practice for VM drive sizes 24 68
    NetApp LUNs and Volumes for Exchange 2016 2 72
    NetApp SnapShot Storage 5 61
    Tape Management 8 32
    Don't buy such-and-such disk drives, they are not reliable!    Boy, how many times have we read a post from a well-meaning person who had some bad experiences with a drive and now they exclaim the entire company's products can't be trusted.  First, …
    I have written before on the benefits of using a Boot media other than your HDD when it has become infected.   The article I wrote about creating a bootable CD/DVD/USB ( was mainly concerned with building a UBCD4Win on CD …
    This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
    This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now