---
title: "How to move Printer Queues to a newly added Pharos Print Server."
slug: "how-to-move-printer-queues-to-a-newly-added-pharos-print-server"
updated: 2024-04-12T14:05:55Z
published: 2024-04-12T14:05:55Z
canonical: "kb.pharos.com/how-to-move-printer-queues-to-a-newly-added-pharos-print-server"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pharos.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to move Printer Queues to a newly added Pharos Print Server.

### Problem:

How to move Printer Queues to a new Print Server

### Applies To:

Printer Queue / Pharos Print Server

---

### Solution:

The printer queues can be moved manually by running a SQL script.

Steps to run the SQL script:

1. Install the Pharos Print Server on the new Server machine.
2. Run the queries against SQL/MSDE Database to modify the server_ID field in the Printers table.

- First determine the ID for the new server by running the following query:

use pharos

select * from servers

- Next run the query to update the server_id field:

update printers

set server_id = '1'

where printer_id = '2'
3. Create printers with identical names on the new Pharos Print Server.

Following the steps above will allow you to simply move the Printers from one server to another and keep all the prior transactions.

## Related

- [Pharos Innovative III Gateway PatronData calls are failing.](/pharos-innovative-iii-gateway-patrondata-calls-are-failing.md)
- [Unable to see the newly added print queue on a clustered printserver after installing a Collector/Tracker on it. And the print queues remain in a "printed" state.](/unable-to-see-the-newly-added-print-queue-on-a-clustered-printserver-after-installing-a-collectortracker-on-it-and-the-print-queues-remain-in-a-printed-state.md)
- [Error Code 29060 "Error while setting KEEPPRINTEDJOBS printer attribute: The printer name is invalid"](/error-code-29060-error-while-setting-keepprintedjobs-printer-attribute-the-printer-name-is-invalid.md)