Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Buster1234 Contributor.
Contributor.
389 views

Moving SQL database to new hardware

I am needing to upgrade my zenworks database hardware and not sure of
the best way to go about it....I am not an SQL wizard, the Zenworks db
is the only SQL servr I am running so what is likely a very easy process
scares me a bit 🙂

The goal is to move from the current hardware with Win2008 R2 and
SQL2008 to new hardware with Windows Server 2016 Standard and MS SQL
2016. The docs say support for SQL only for 2014 but I assume the new
version of Zen that is coming out "soon" will work with 2016. If I must
use SQL 2014 that's what I'll use.

We are currently on 11.4.2. I have 3 linux primaries.

I saw the directions on the docs to change the database settings in ZCC
for moved/migrated database but I am not really sure the best way to get
the step one (ie actually have 2 databases and need to change the
settings in ZCC).

Anyone have a guide or howto for this?

Thanks
Buster
Labels (2)
0 Likes
1 Reply
Knowledge Partner
Knowledge Partner

Re: Moving SQL database to new hardware

Buster,
> Anyone have a guide or howto for this?


Well, moving an SQL database, is a no-brainer. You can use SQL Data migration, or simply do a backup and then restore to the new box.

As for ZCM: https://www.novell.com/documentation/zenworks114/zen11_sys_db_mgmt/data/bfxsr85.html

--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)

Have an idea for a product enhancement? Please visit:
https://www.novell.com/products/enhancement-request.html

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.