Restore Vault

First you probably want to copy the vault on the test server to get an empty vault without any test objects in it.
Be careful to get the content of value lists and other relevant content included in the copy.

When ready you must take the vault off line in MF Admin
Then you need MS SQL Server Management Studio to connect to the SQL server and create a backup of the database.
Copy the backup file and the File data folder on to the production server.
Use MS SQL Server Management Studio to restore the database.
Use MF Admin to Attach the document vault.

Thanks for the instruction guide line.

i got the following error

Thanks for the instruction guide line.

i got the following error

Ensure that you've read this document, and the documents it links to.  If the versions of M-Files are the same on both servers then my guess is that some step has been missed somewhere: Maintenance Guidelines for M-Files Administrators.pdf