Q about upgrading MS SQL in-place from 2005 to 2008, and SQL
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.EDU
] On Behalf Of Michael Leone
Sent: Wednesday, February 01, 2012 8:05 AM
To: NETWORKER < at > LISTSERV.TEMPLE.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.gov>
and type "signoff networker" in the body of the email. Please write
to networker-request < at > listserv.temple.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
via RSS at
http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
