I need to get a backup dump of a large (~8gb) svn repository. My current method involves using svnadmin dump to a file and then using 7-Zip to compress and split the file. > svnadmin dump c:\path\to\myrepo > c:\svndump.svn > 7z svndump.svn svndump.7z // or whatever the correct syntax is I was wondering if there would be a way to ...
I need to do a full backup of a SharePoint app running on our production server to a our test server running SharePoint. I tried using Central Admin to back up from the prod server, zipping up the backup and then restore to the test server, but this doesnt work. Whats the easiest way to do this? ...
What are my options if I want to just backup my data directories on Windows 2008 Server. It looks to me like the backup software built into the OS only backs up an entire hard drive. Is my only option to copy the files? ...
How can you insert the date in the filename (a dynamic filename) used in a T-SQL backup script? Using SQL Enterprise Manager to create and schedule a backup job, I'd like to edit the T-SQL created to change the filename of the backed up database to be dbname_date.bak (i.e. northwind_5-1-2009.bak). The next time the backup runs, it will...
I’m trying to backup a SQL08 database to a target on a remote drive and keep ending up with error reason “1815”. This happens either when scripting the backup or using the task wizard GUI. It also occurs when attempting to use either UNC or a shared drive letter to the same path. Another machine on the network doesn’t have a problem back...
I am looking at writing a program (.Net)for backing up files on a computer. How would I go on about knowing what files have changed to backup (I don't really want to scan the last modified dates each time. Are there any backup algorithms for backing up only the bits of a file have changed. What are the O notations for the algorithm? ...
Hi, I am using Command line to backup and restore MYSQL Database. Let use I m having a Database Data1 having Views and Procedures in it. When in Cmd line, I use mysql dump i.e ..>bin> mysqldump -u root -proot Data1> Datafile.mysql When I use above Cmd, It creates a Backup file on bin Folder of Mysql with Dtafile.mysql Name. but the ...
I have around 400 GB Live mysql Databases on one server and I like to create a mirror for this database. In the server I have database ranging from 1 GB to 100 GB. What are the best practices available that I can use? My purpose is that I should be able to switch in case of emergency. It should have all live data. Thanks. ...
I have a host which runs SQL Server 2005, I have the ability to login to my database and copy/read/write/drop all tables/views/sp's. I tried simply right clicking on my server and selecting backup but I don't seem to have permission to do any backing up. This cannot be an uncommon occurrence (someone using host/providers db). Has ...
Hi All, Me and my colleague are trying to implement a mechanism to get recovery from broken files on an embedded equipment. This could be happened during certain circumstances, e.g. user takes off the battery during file writing. Orz, but now we have just one idea: Create duplicated backup files, and copy them back if dangerous file...
is there a good way to back up all the code and content on an SVN server? because if that hard drive dies, then all work can be lost. i think if we use multiple computers to SVN Update to it regularly, the most of the files are present on those machines, and therefore the code are somewhat safer not to be lost. i was also thinking of ...
This question might make one smile, really, HDD space is as cheap as dirt today. But nevertheless, with extremely slow internet connections (which is still the case in the major part of the world) transferring backups from different branches might be real pain in the back. So, do you have any ideas on how to decrease database file size ...
Need to provide this facility on a button-click in my web application. Could be done using mysqldump, but for that I'd have to start an external process? (the command prompt) Is there a simple SQL query that lets us backup and restore databases? (particularly for MySQL) ...
I have an SQL 2005 database with logging set to FULL but without any backups. Is it possible to restore it to a point of time? ...
Hi all! I'm looking for some help/suggestions for backing up two large databases to one server dedicated to reports. The situation is; My company has two databases for its internal website. One for the UK and one for Europe. Both are mirrored for DR. I have a server based in Europe which is dedicated to Microsoft Reporting Services, w...
Does any one know if there is a way to script out SQL Server backup in to a batch file, so that it could be executed from a command line? ...
I use mysqldump with mysql 5.0 and I back it up every day, but do not understand the method that only stored procedure backs up. How can I back it up? ...
Hi, I have a website I've created in Visual Studio 2008 and I need to take it live. How can I backup the database file to a .bak so I can hand it over to the hosting company to place on the server? ...
Is it possible to restore a backup of a SQL Server 2008 database onto an instance of SQL Server 2000? I need to work on an sample application for which database backup is in sql server 2008. But I'll not be able to install 2008. So is it possible to restore that back up in 2000? ...
I run VMWare Workstation 6.5 on WinXP. How can I script a way to automatically clone my VM images? I've read about the "vmware-cmd" tool but believe that is only available with VMWare ESX, not Workstation. ...