Networker

Re: [Networker] Q about upgrading MS SQL in-place from 2005 to 2008, and SQL Module

2012-02-01 12:14:33
Subject: Re: [Networker] Q about upgrading MS SQL in-place from 2005 to 2008, and SQL Module
From: Michael Leone <Michael.Leone AT PHA.PHILA DOT GOV>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Wed, 1 Feb 2012 12:14:07 -0500
> Answer is No.  Backup will work as is and there is no need to 
> reinstall the NMSQL application.

Great! I love it when I don't have to do anything to make sure stuff still 
works as expected. :-)

> Note:-
> It is highly advisable to take the FULL backup for the DB's after 
> the successful upgrade of the SQL instance. 

We do FULL backups of the DBs every night. (we don't like incremental 
backups for DBs )

Thanks for the confirmation. 


> 
> 
> Michael Jones
> Principal Product Manager - Microsoft
> EMC Backup & Recovery Systems Division
> EMC Corporation
> 
> 
> 
> -----Original Message-----
> From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU
> ] On Behalf Of Michael Leone
> Sent: Wednesday, February 01, 2012 8:05 AM
> To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
> Subject: [Networker] Q about upgrading MS SQL in-place from 2005 to 
> 2008, and SQL Module
> 
> We have a MS SQL 2005 cluster, and we use the SQL Module to back it up. 
> This weekend, we're going to be upgrading (in-place) from SQL 2005 to 
SQL 
> 2008. Do we need to do anything with the Networker SQL Module, such as 
> re-installing it?
> 
> I think: no. The actual cluster is keeping the same DNS name, and same 
IP 
> address. So I don't think I need to re-install anything. The scheduled 
> backup jobs (which specify saveset of MSSQL:) should continue to Just 
> Work, as the client info (DNS, IP) will continue to be what Networker 
> currently thinks they are.
> 
> Correct?
> 
> Current SQL Module is v5.2.2.23 (64bit), and the Networker Client is 
> v7.6.2.3 (64 bit). Client OS is Win 2008 R2 Enterprise.
> 
> -- 
> Michael Leone
> Network Administrator, ISM
> Philadelphia Housing Authority
> 2500 Jackson St
> Philadelphia, PA 19145
> Tel:  215-684-4180
> Cell: 215-252-0143
> <mailto:michael.leone AT pha.phila DOT gov>
> 
> 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
> 

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