ADSM-L

Re: [ADSM-L] sql server restore to different server

2008-03-10 05:48:45
Subject: Re: [ADSM-L] sql server restore to different server
From: Jeff White <Jeff.White AT WOOLWORTHS.CO DOT UK>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 10 Mar 2008 09:47:19 -0000
That second line should of course have read:

"I can restore server SERVER1 to server SERVER2" 

Apologies


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Gill, Geoffrey L.
Sent: 08 March 2008 03:09
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] sql server restore to different server
Importance: High

No replies on the first post so let's try this. We have NT4 back up on a
box running sqlserver but the guy did not name the sql server the name
it was backing up under. My guess is this is why we are seeing nothing
looking to restore the db's. Having never done this, how can I restore a
database backed up on a sql server, call it server 1, to server2? So far
my attempts at trying to use the tdpsql.cfg for this, which is where the
from and to options are, have not worked.

 

Thanks for any quick and easy help anyone can supply. In the mean time I
also asked the person who made this to change the name of the sqlserver
to the old name it was backed up under to hopefully solve the problem
quicker. 

 

 

Geoff Gill 
TSM Administrator 
PeopleSoft Sr. Systems Administrator 
SAIC M/S-G1b 
(858)826-4062 
Email: geoffrey.l.gill AT saic DOT com 
------------------------------------------------------------------------
--------------
Email scanned for viruses and spam by the Woolworths
anti-virus systems.

If you believe this email is spam, please forward to
suspectspam AT woolworths.co DOT uk
****************************************************************************
Woolworths plc
Registered Office: Woolworth House, 242/246 Marylebone Road, London NW1 6JL 
Registered in England, Number 104206

This e-mail is only intended for the person(s) to whom it is addressed and 
may contain confidential information.  Unless stated to the contrary, any 
opinions or comments are personal to the writer and do not represent the 
official view of the company.  If you have received this e-mail in error, 
please notify us immediately by reply e-mail and then delete this message 
from your system. Please do not copy it or use it for any purposes,  or 
disclose its contents to any other person.  Thank you for your co-operation.
****************************************************************************
------------------------------------------------------------------------------------
Email scanned for viruses and unwanted content by emailsystems

Information regarding this service can be found at www.emailsystems.com
<Prev in Thread] Current Thread [Next in Thread>