SQL Server file backup

Hi Experts,
I run SQL 2005 in VM  Player.
I want all mdf and ldf files to be backed up in the host OS.
as my host OS continuously gets backed up.
Is there any solution?
I tried using Goodsync.
But it can not copy files as files are locked by sql server and it can not access files.
I am looking for some sort of open source software which allows me to achieve backup.
I want to setup the backup so that files are backed up after every hour.
so that, If I make any change in the database, they are passed to host OS.
Thanks
LVL 14
pradyahujaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
You may want to take a look at this...

http://www.veeam.com/vmware-esx-backup.html
0
pradyahujaAuthor Commented:
@Racimo
I only want to backup sql files.
and also looking for either open source or some free software
0
jermorseCommented:
You could set MS SQL 2005 to actually create .bak files for you every hour but keep only as many .bak files as you want to keep.

Or you could try a syncronization software tool like SyncToy or RSync to see if they will allow you to sync the mdf/ldf files from the host OS disc to a separate disc.

SyncToy 2.1
http://www.microsoft.com/downloads/details.aspx?familyid=c26efa36-98e0-4ee9-a7c5-98d0592d8c52&displaylang=en

RSync
http://samba.anu.edu.au/rsync/
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

blandyukCommented:
You need to create SQL backup files of your databases. You can create differential backups every 2 hrs or whatever to supplement your initial backup. Please note that you can only backup to your local drives or iSCSI drives.

With regards to copying the files to your host box, as above or you can also use robocopy from MS:

http://www.microsoft.com/downloads/details.aspx?FamilyID=9D467A69-57FF-4AE7-96EE-B18C4790CFFD&displaylang=en

robocopy source destination /MIR /R:1

Mirror directory and retry only once.
0
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
A cheap workaround: if you can map one VM drive onto the host machine then you can run backup using the SQL Server engine. Alternatively you can stop the service periodically then copy the data files onto the mapped drive but that's poor practice...
0
marirajuCommented:
Instead of using any third party software you can really make it happen from the tolls you have.
If you are using VMware, make sure that the Network and File Sharing is enabled so that you have access to the network PC or your local host PC.
From SQL server you can easily create a JOB and make it run every hour, which will backup the database and put it into the location you have selected from the Network.
To ease the process, try creating a Backup device from the SQL server and point the back to the backup device. Remeber that the Backup device will be pointing to the location on the network PC or the Local host PC. You can accomplish this just by the GUI provided by the MSSQL server. Please do let me know if you have any further questions.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server Apps

From novice to tech pro — start learning today.