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?
 
marirajuConnect With a Mentor Commented:
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
 
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
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
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
 
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
All Courses

From novice to tech pro — start learning today.