Networker

[Networker] Moving clients between 2 environments

2009-01-28 15:42:18
Subject: [Networker] Moving clients between 2 environments
From: JackTFECow <networker-forum AT BACKUPCENTRAL DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Wed, 28 Jan 2009 14:43:51 -0500
I had a ticket generated at EMC for this, and unfortunately they have told me 
there is no way to do what I am attempting to do.  Being that I have been told 
this in the past, and found that they were wrong by checking the boards here, I 
thought I would post the information and what I am attempting to do.  Maybe 
someone here can actually answer this.

The environment:
We have 2 backup servers.  One handles production, and one handles QA/FT/DV.  
Both systems are windows and both are running 7.4.4.  The production system has 
LTO-4 drives (we use 3 and 4 tapes for backups and clones).  The non production 
system is LTO-2, and has more drives.

The problem:
The DBAs here run scripts to do transaction logs and random backups/recoveries 
at all hours of the day/night.  This has caused many problems on the production 
system, as the LTO-4 drives have been fickle at best lately.  Every time I take 
the system for an outage the DBAs complain.  The beginning of the week has been 
a nightmare because we try to get all the cloning done as fast as possible so 
it can go offsite by Wednesday.  Because the production system has fewer 
drives, and far more to do from Sunday through Wednseday morning, I am looking 
to move the SQL clients to the non production backup server.

My solution:
Moving the SQL clients to the non production backup server allows more 
flexibility with the backups and cloning process.  Moving the clients is easy 
enough to do.  Cloning isn't a problem either.

What I need help with:
At the DR site we only bring up one backup server, the production one.  We only 
have one library at the DR site, and depending on the test year, only 3-4 days 
to bring the whole production site up.  There is no time to scan all the SQL 
tapes in from the non production backup server to the production one.  We need 
to bring the backup server up and get the backbone systems up as fast as 
possible and then start running restores immediately.  What I need is a way to 
get the indexes of just the SQL clients merged into the production system 
without having to scan the approximately 15 tapes the data will be on.

What I have tried so far:
I have tried running a bootstrap from the non production system and scanning 
just the indexes for the clients I need onto the production server (I have the 
SQL clients on both backup servers using the same client ID) but the saveset 
just shows up as Recoverable (cr flag).  None of the savesets show up, so this 
is no working.  Like I stated in the beginning, EMC support claims that there 
is no way to achieve what I need.

Any ideas?  I am open to trying most anything at this point.  I can get the 
approvals to move the clients, I just need to prove that we can move a client 
and that we will not spend the first 20 hours at the DR site scanning tapes...

+----------------------------------------------------------------------
|This was sent by JackTFECow AT yahoo DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

<Prev in Thread] Current Thread [Next in Thread>