We help IT Professionals succeed at work.

Backup Citrix XenApp 65 MF20.dsn database

divich
divich asked
on
370 Views
Last Modified: 2017-06-03
What is the procedure to backup the local (SQL server express) Citrix database: MF20.dsn ?
I did some backups of my SQL Express Database using dsmaint backup but i end up with a MF20.dat backup file instead of a MF20.dsn file?
I have read that dsmain backup should be used for backing Access databases but not SQL or Oracle databases.

1- I also found an article that was saying that dsmaint Backup worked with "SQL express database"! Is that ok to do that?
2- Can I just take a vmware snapshot of the server that contains that MF20.dsn database?
3- What is the procedure to restore the MF20.dat that i got with dsmain Backup?

Thanks.
Comment
Watch Question

Sekar ChinnakannuStaff Engineer
CERTIFIED EXPERT

Commented:
Command should be dsmaint backup "C:\Program Files (x86)\Citrix\Independent Management Architecture\MF20.dsn
For more details https://docs.citrix.com/en-us/xenapp-and-xendesktop/xenapp-6-5/xenapp65-w2k8-wrapper/xenapp65-admin-wrapper/ps-commands-wrapper-v2.html
divichIT

Author

Commented:
I am sorry Sekar but you should never do that!!! This command will damage the database.
The command is correct but you should change the path like dsmaint backup C:\ or change the name of the database MF20NEW.dsn.
If not it will just replace the existing database since they have the same name!
Look at this article:
https://citrixxperience.com/2012/09/12/dsmaint-backup-citrix-xenapp-with-ms-sql-server-express-database-data-store/
Sekar ChinnakannuStaff Engineer
CERTIFIED EXPERT

Commented:
it should be like dsmaint backup c:\backuplocation where the command will help you to copy mf20 file which has the details of ms20.dsn file. Which is under C:\Program Files (x86)\Citrix\Independent Management Architecture\MF20.dsn, once you done with the back up use dsmaint recover to restore.
Carl WebsterCitrix Technology Professional - Fellow
CERTIFIED EXPERT
Most Valuable Expert 2019
Top Expert 2010

Commented:
The DSN file is NOT the database. That is just a text file you can copy to wherever you want to copy it. There is no special backup process for that file.

http://carlwebster.com/learning-to-migrate-a-citrix-xenapp-6-x-data-store-from-sql-server-express-to-sql-server/

Go down to Figure 3. That shows you what you need.
divichIT

Author

Commented:
Hi Carl,
My database is on one of my XenApp servers. Not on an SQL server. It uses SQL Express.

I tried to copy the all folder C:\Program Files (x86)\Citrix\Independent Management Architecture but cannot copy everything because in use (in production)!

So how can I back it up?

Would a snapshot of that server would be ok?
As attachment you can see that my database is local to that server (SQL Express).
If I edit the mf20.dsn as a txt file here is what i see:
[ODBC]
DRIVER=SQL Server
DATABASE=MF20
APP=Citrix IMA
UID=Administrator
SERVER=(local)\CITRIX_METAFRAME
Trusted_Connection=Yes

As you can see I am logged on the XenApp server that has the database ( SERVER=(local)\CITRIX_METAFRAME )

Thanks.
Database.png
Carl WebsterCitrix Technology Professional - Fellow
CERTIFIED EXPERT
Most Valuable Expert 2019
Top Expert 2010

Commented:
Use the dsmaint command to backup the SQL Express database and you can also keep a copy of the mf20.dsn file.

dsmaint backup d:\BackupFolder (where "d" is the drive containing the backup folder.
divichIT

Author

Commented:
Hi Carl,
Thank you for your answer. I did the dsmaint backup d:\BackupFolder but that gives me a mf20.dat file that is 30.3 MB?
If that is what you are talking about Carl, how would I restore that .dat file in case i need to?

If I try to copy the all folder (IMA) that contains the mf20.dsn it doesn't copy everything; it seems i need to stop the IMA service maybe; but I am afraid to do that in production!
Also if i copy the mf20.dsn, the backup is only 134 bytes! So I guess it is not complete?
Now the MF20.ldf is 13 MB and the MF20.mdf is 31 MB
Citrix Technology Professional - Fellow
CERTIFIED EXPERT
Most Valuable Expert 2019
Top Expert 2010
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
divichIT

Author

Commented:
Thanks so much Carl. You are awesome. )))
Carl WebsterCitrix Technology Professional - Fellow
CERTIFIED EXPERT
Most Valuable Expert 2019
Top Expert 2010

Commented:
Correct answer
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.