Create the SQL Server Maintenance Plans - Create the SQL Server Maintenance Plans - Moving INOW Database from SQL Server to another SQL Server Machine - Foundation 25.1 - Foundation 25.1 - Ready - Perceptive Content - external - Perceptive-Content/Moving-INOW-Database-from-SQL-Server-to-another-SQL-Server-Machine/Foundation-25.1/Moving-INOW-Database-from-SQL-Server-to-another-SQL-Server-Machine-Best-Practices/Moving-the-INOW-Database-from-SQL-Server-to-Another-SQL-Server-Machine/Prepare-to-Move-the-Database/Create-the-SQL-Server-Maintenance-Plans - 2025-07-21

Moving INOW Database from SQL Server to another SQL Server Machine Best Practices

Platform
Perceptive Content
Product
Moving INOW Database from SQL Server to another SQL Server Machine
Release
Foundation 25.1
License
ft:lastPublication
2025-07-21T12:16:52.932000
ft:locale
en-US

To create new backups of the INOW and system databases on the new server, complete the following steps.

  1. Manually create and execute the SQL Server Maintenance Plans.
  2. Create maintenance plans to periodically rebuild indexes and gather statistics on the INOW database.
  3. Schedule the maintenance plans to run at regular intervals.
  4. Copy all backups to tape.