Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2006-03-22
Medium Priority
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

Accepted Solution

IPKON_Networks earned 2000 total points
ID: 16263107
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
ID: 16263326
Use the redirect option in the restore options screen.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
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…
Suggested Courses
Course of the Month15 days, 13 hours left to enroll

580 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