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

Question

Question

Copying repository and DB to a new server

Version 9 Laserfiche
Updated April 16, 2014
asked on April 15, 2014

 

 

We have a 2003 server running a United system. Everything is ran off the 2003 server. They purchased RIO. We installed the RIO system on a new 2012 server. They would like to keep the United system up and running while we get the RIO system going. How can I copy the files from the database and repository over without detaching the repository and database.

 

What I have done for the Database is just did a full backup and then restored the full backup to the new 2012 mssql studio. Do I still need the .LDF and .MDF files? How can I copy those over if so? It tells me that they are in use so I cannot copy them. Do I just need to stop the mssql service?

 

At this time both systems are licensed and running. The previous United system was poorly configured and we want to have the new RIO corrected before pushing it out. So we would not need an eval license. Really we just need to copy the DB over.

 

What is the best way of going about this?

0 0

Answer

SELECTED ANSWER
replied on April 16, 2014 • Show version history

If you've done a SQL backup and restore, then there is no need to bother with the MDF and LDF files. The restore process recreates those on the destination server.

 

In order to get the actual image data you'll probably need to do a backup/restore operation there as well. There's no way to export an entire running repository.

 

Keep in mind that at some point you will need to take the existing server offline or at least put the repository into read-only mode in order to make sure that people can't make changes on the old server that don't get copied to the new server.

 

EDIT: Make sure that you capture the two backups relatively close to each other, preferably with the image backup being slightly before the SQL backup. Then play the transaction logs in the SQL backup up to the point where the image backup was taken. This will reduce the number of orphaned documents. You won't need to worry about this when you do your final migration, but it's good to keep in mind any time you are doing a backup/restore of Laserfiche.

0 0

Replies

replied on April 16, 2014

Unfortunately, you cannot simply copy the repository.  Each Laserfiche repository is assigned a universally unique identifier (UUID). Laserfiche embeds the UUID within various internal data. This means that you cannot simply create a copy of the SQL database associated with one repository and register a second repository using that copy of the database.

You can modify the copy however.  See: https://support.laserfiche.com/KB/1012907

1 0
replied on April 16, 2014
0 0
replied on April 16, 2014

We do not want to unregister the repository or disconnect the DB. They want to be able to use the the United while we are configuring the RIO. This is not a move/transfer. We just want to copy....

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

Sign in to reply to this post.

Details
Related Posts
Loading ...