INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
Are you a
Computer / IT professional?
Join Tek-Tips now!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
Favorite Forums
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
Feedback
"...I just wanted to say THANKS for the forum. The knowledge I gain from your site is invaluable..."
Geography
Where in the world do Tek-Tips members come from?
|
DB Agent Tips
|
How can you restore a SQL database to a different location or database
Posted: 21 Jan 04
|
Got these notes from a friend who is a SQL guru. It is for SQL 7 but I think the steps are the same, just a different path.
If you are restoring a database with SQL 7.0 to an alternate location but the database name will be the same do the following:
1. create the database
2. select the database in the restore screen, right click select DB agent options.
3. Put a check mark next to Force restore over existing database
4. Select the alternate destination Server then MSSQL server
5. Perform the restore
To do a restore to an alternate database do the following:
1. select the database in the restore screen, right click select DB agent options.
2. under the section "restore database files as:" select each object and change the name of the files so that the prefix to the file name reflects the name of the new database that you want ARCserve to have created i.e.:
by default it will have the original path and file name that you were going to restore
Example:
ASDB
backed up from
d:\mssql7\data\ASDB_Log.LDF
d:\mssql7\data\ASDB_Data.MDF
but I want to restore it to a server that has the data file on C: and the new database that I want to create is call TEST, I will change it to the following:
c:\mssql7\data\TEST_Log.LDF
c:\mssql7\data\TEST_Data.MDF
and then select OK to close the window
3. For the destination I will deselect original find the server select MSSQL server and then type in a \test to make my restore path:
\\<server name>\dbasql70\test
4. run the restore
Note: In a few cases the SQL query tool had to be used in order to bring the database up after the restore using the following command:
restore database using with recovery
restore database test with recovery |
Back to CA: ARCserve back-up FAQ Index
Back to CA: ARCserve back-up Forum
|
|
 |
|
Join Tek-Tips® Today!
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Talk To Other Members- Notification Of Responses To Questions
- Favorite Forums One Click Access
- Keyword Search Of All Posts, And More...
Register now while it's still free!
Already a member? Close this window and log in.
Join Us Close
