For example when editing various data files, the backup data is no use and actually trips up our tools. So I'd like to be able to disable backup for files containing a regexp in the name. justinhj ...
Is it possible to restore a MySQL database from the physical database files. I have a directory that has the following file types: client.frm client.MYD client.MYI but for about 20 more tables. I usually use mysqldump or a similar tool to get everything in 1 SQL file so what is the way to deal with these types of files? ...
I'm running a small web application with SQL server express (2005) as backend. I can create a backup with a SQL script, however, I'd like to schedule this on a daily basis. As extra option (should-have) I'd like to keep only the last X backups (for space-saving reasons obviously) Any pointers? [edit] SQL server agent is unavailable in ...
I'm trying to backup a database in SQL Server 2008 and have the database compressed using the new compression feature. However, when I run the following code, I get a weird error message: Backup Database <Database> To Disk 'C:\Backup' With Compression I get this error message: Backup Database With Compression is not supported on S...
Hi there, currently I have a full backup running daily in SharePoint. The automated process for further copying, renames the full backup directory to backup_((date in yyyymmdd))_full. I'd like to rework to a daily incremental/weekly full schedule, but the differentials can't seem to find the last full backup to work with. I was thinki...
What are the recommendations of software products for creating automated backups of SQL Server 2008 databases? The backup should happen without taking the database offline/detatching. ...
My log file in SQL Server used up all the space on my disk. I run full backups every night, but the log file keeps growing. What can I do? ...
Hello. I've inherited a Ruby on Rails application that has a problem. I'm half way through some books on Rails, but haven't seen the answer to some questions yet. What is the best way to backup the application? Can I just tar -cvzf app.tgz app? I don't know yet if the app has a sqlite3 database or connects to a db server. What's the b...
This question might be kind of elementary, but here goes: I have a SQL Server database with a 4 GB log file. The DB is 16GB and is backed up nightly. Can I truncate the log regularly because the entire DB+Log is backed up each night? ...
I'm implementing Backup functionality into my new (small) app, Oldaer. I've got standalone desktop files (rather than sitting in a SQL db). Looking around, I decided on using a Clarion 3rd-Party Template that will package them into one file and then compress (huffman's) that one file. Restoring is just the reverse. Uncompress, unpack. ...
I want to both backup my Xampp directory and also transfer it to another computer. Is there an easy way to do this? When I try to copy it, it gives me a restriction, even though I am not running xampp at the time. Thank you! ...
Hi, I'm having serious issues with backing up and restoring a shared services provider. Using the Central Administration backup I run the backup to s:\ This completes fine. I then from another SharePoint Server choose to restore a backup and point it to the UNC path \machineipaddress\s$\spbr00DF I have given everyone full access to ...
A) What is the best solution for regularly backing up large PostgreSQL database (version 8.3 running on latest Ubuntu server); please don't say pg_dump with those painfully slow insert statements B) What is the best solution for PostgreSQL database replication that works in real world ...
Hi folks, i'm trying to restore our live DB onto our Dev box. To do this, I when onto production, TASKS -> backup Db. it created a 4Gig file. I zipped this down to 2.2Gig. download that to my dev server. On my dev server, i create a new DB (called 'xxxxx') and then Tasks -> restore DB from file. I give it the .bak file name, overwrite ...
I'm not clear about the interaction between database schema changes and differential backups on sql 2005. Lets say I do a Full backup right right now. Then I perform some schema changes. Then I do a diff backup. What happens? Do I need to create another FULL backup? Are my schema changes and any data in those new schema bits included...
i backed up a data: BACKUP DATABASE MyDatabase TO DISK = 'MyDatabase.bak' WITH INIT --overwrite existing And then tried to restore it: RESTORE DATABASE MyDatabase FROM DISK = 'MyDatabase.bak' WITH REPLACE --force restore over specified database And now the database is stuck in the restoring state. Some people have theorized ...
Imagine you sell an application that stores its data in a Microsoft Sql Server database. Some customers are large companies with existing Sql installations and staff to maintain them. Other customers are small companies who get the SQLEXPRESS version installed by a setup program. The database will soon contain a lot of important data an...
Hi, I've used the central admin backup facility to backup our Shared Services Provider. The backup location was a drive on a new server. I then try to restore the SSP via central admin on the new server. It fails with an error relating to the fact that it cant find the .mdf files that it requires. It is looking in the location that the...
I've long been using subversion (and before that CVS) to store not only source files but later the LaTeX files for my research and eventually some word files and other materials. I like the fact that I can work with multiple computers and synchronize the latest things from each, while still being able to maintain some hierarchy of my ba...
Hi, I'm using SQL Server 2005. I need to move a database to a new server with minimum downtime. Currently my option is to take everything offline, perform a backup, copy the backup to the new server, restore the backup and bring everything back online. The problem here is that the backup file is about 10Gb, therefore, it takes about ...