You are viewing limited content. For full access, please sign in.

Question

Question

SQL Migration

asked on April 11, 2018

I am looking for information on SQL migrations. we are moving the SQL server to a new physical box. One method I believe would work is to shutdown Laserfiche, backup the SQL server at the server level and then restore it to the new box and point Laserfiche to the new path.  

 

Is this a viable method? is anyone able to point me to a white paper or some other documentation for this task?

 

Thanks.

0 0

Replies

replied on April 11, 2018

That is really all there is to it. The software just needs to know where it's data resides. The only thing that is changing is the server name/ip, and optionally the SQL credentials and/or Database name. Each Laserfiche product (that requires a database) has an option to update this either in the configurator or the administration console.

Just make sure no users are accessing the system before you start the backup, by shutting down the services, this way they don't make changes.

You can create a SQL backup and restore, or shut down SQL, then move or copy the MDF/LOG files.

I prefer taking a fresh backup file rather than "moving" anything over. This also cleans up the logs and fragmentation.

0 0
replied on April 12, 2018

If the old server is going away, you can give the new one the same name and you don't have to change anything in your configuration.

0 0
replied on April 12, 2018

Sure can, if the name matches exactly, with the same credentials and database name, nothing needs to be updated in the config. Just starts the services and they will not know the difference.

0 0
replied on April 12, 2018

Check out the 'Database Backup' section of this white paper.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.