Clicky

Citrix Datastore Backup and Recovery

32 Flares Twitter 9 Facebook 13 Google+ 4 Pin It Share 0 LinkedIn 6 Email -- Buffer 0 32 Flares ×

Citrix DataStore Backup and Restore 300x187 Citrix Datastore Backup and Recovery

In this post I’m going to show you how to automatically backup and restore your Citrix DataStore Database on SQL Server Express. First you’ll need to download and install Microsoft SQL Server Management Studio and then connect to your server.

Backup :

Right click your Citrix Datastore Database and select Tasks – Backup.

Citrix DataStore Backup and Restore 01 300x187 Citrix Datastore Backup and Recovery

Use the default settings on the General and Options tab. If you’re using SQL Server Express select Script Action to File from the Options tab. If you’re running a full blown SQL Server select Script Action to Job.

Citrix DataStore Backup and Restore 03 300x187 Citrix Datastore Backup and Recovery

Save the SQL Server Script file in your preferred location. In this example I’ll be using C:Program Files (x86)Microsoft SQL Server.

Open up Notepad and paste the content below (double click to mark and copy). These commands will automatically backup the SQL Database and then copy the XA6DB.bak to a network share. This way you can easily go back in time and restore your database even if your SQL server has crashed.

[sourcecode language="plain"]
"C:Program Files (x86)Microsoft SQL Server90Toolsbinnsqlcmd.exe" -S DC01SQLEXPRESS -i "C:Program Files (x86)Microsoft SQL ServerXA6DBBackup.sql"
xcopy "C:Program Files (x86)Microsoft SQL ServerMSSQL.1MSSQLBackupXA6DB.bak" "%XA%BackupXA6DBBackup" /Y
[/sourcecode]

Finally we need to create an Schedule Task in Task Scheduler.

Citrix DataStore Backup and Restore 07 300x205 Citrix Datastore Backup and Recovery

Restore :

You can restore the database any time. Right click Databases and select Restore Database.

Citrix DataStore Backup and Restore 08 300x187 Citrix Datastore Backup and Recovery

Choose your target and source database.

Citrix DataStore Backup and Restore 09 300x187 Citrix Datastore Backup and Recovery

Like what you've read?

If so join over 20.000 people and receive FREE Citrix XenApp
and XenDesktop Training, blog updates and information on
upcoming webinars. Click the red button below!
 Citrix Datastore Backup and Recovery

Leave a reply

Name: Email:
32 Flares Twitter 9 Facebook 13 Google+ 4 Pin It Share 0 LinkedIn 6 Email -- Buffer 0 32 Flares ×