backup

how to schedule backup in sql server 2008 ?

how can I schedule daily backup at 9:00pm in SQL server 2008? ...

Plink command is invalid to cmd.exe

I am trying to throw a plink command to my esx server and grep the linux output of the command. The code above does not work. But if I remove the | grep part it works again. Is there any other way to achieve the same results but making the command passable with cmd.exe? FOR /F "TOKENS=1 DELIMS=:" %%A IN ('TYPE %SYSTEMDRIVE%\Users\Ian\De...

PostgreSQL Error: geometry contains non-closed rings

I am desperately trying to backup using pgAdmin III my database and I receive an error: geometry contains non-closed rings. How can I get around this?? ...

Generation of backup puts my website down - is there an easy solution?

Hi. On my database server there is a cronjob that backups all the databases in a way that makes it easy to restore them. It is something like this: 0 5 * * * /usr/local/bin/backup.php The problem is that the website (using that db server) is very slow during that process. Even, Pingdom sends me a 'website down' alert at the start of ...

VB.NET - SqlException: Could not locate entry in sysdatabases for database...

Hello, I want to backup my database using Linq to SQL: Dim sql As String = "BACKUP DATABASE SeaCowDatabase TO DISK = _ '" + sfd.FileName + "'" db.ExecuteCommand(sql) But instead, I get this error: System.Data.SqlClient.SqlException (0x80131904): Could not locate entry in sysdatabases for database 'SeaCowDatabase'. No entry fo...

SQL Server backup causes recent table records to disappear for one table

I just noticed two months after switching out a backup drive that one table in one of the backed-up databases is losing records past a certain point. The database is backed up weekly. Prior to the new drive, the table had records from 3/11/2010 to 6/8/2010. After the first backup ran, the table was missing all records past 3/11/2010,ex...

inserting date into sql script

i am doing sql server backups like this in script: BACKUP DATABASE databasename TO DISK = `path' since this backup is going to be automated, how do i insert today's date into 'path' ? ...

Mysql incremental Backup

Hello Everyone, Can anyone help me to take incremental backup in mysql. i had some idea about that but it is not cleared in my mind , please give solutions in steps Thanks in advance!!! Riddhi ...

How to restrict user to take data back up of our application data through itunes sync process? through coding

Hi, how do i restrict taking an application data backup using itunes sync.. its a requirement from my client that ....from application should not allow taking a backup of any files. Can you please suggest me whether this is possible or not.... if yes can you please suggest me ways to do it.. ...

back up a database

Hi everyone, I need to back up a big database everydays. Should I code it myself in PHP or is there a good script out there ? ...

How to use mysql dump in php

I've tried using mysql dump in the command line and it worked. How do I do it in php? I found this code from the internet, and tried it. <?php ob_start(); $username = "root"; $password = "mypassword"; $hostname = "localhost"; $sConnString = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL"); $conn...

Windows Volume shadow copy error: 2155348129

Developing a VSS writer app: see this error during backup, initiated by windows backup tool, is there defined error codes for 2155348129 from Microsoft? "The backup operation that started at '‎2010‎-‎07‎-‎20T02:54:19.354000000Z' has failed because the Volume Shadow Copy Service operation to create a shadow copy of the volumes being back...

JPA 2 Delete/Insert order from Metamodel

I'm trying to use the JPA2 metadata to figure out the order to insert/delete rows from a database so constraints are not an issue (to be used later in Java code). This is part of a backup/restore approach using JPA. Here's my approach: Group tables by amount of relationships/constraints (Only one-to-many and one-to-one are considered)...

How/Where to back up local checkout of a DVCS between pushes to the server?

Do you (and your team) back up your local checkouts of your DVCS (Git, Mercurial) repository between pushes? How do you do so? If your hard drive were to fail after writing a bunch of code that was not yet stable (therefore not yet pushed), how would you get it back? ...

Realtime backup to an external NAS drive

Just wondering if anyone can recommend freeware software to backup files in a particular folder on my machine to a NAS drive in real time. I.e. I change a file, and it gets backed up quite soon afterward. I.e. it would be kind of like dropbox, but without the online component. Thanks. ...

Data Protection Manager Performance Impact

Has anyone study the performance impact (positive or negative) of using Data Protection Manager as a backup and recovery tool for SQL Server? ...

Restore of MySQL Backup just stuck

I have a with mysqldumb created backup file. It's about 15GB and contains a lot of blobs. Max size per blob is 30MB. mysqldump -uuser -ppass --compress --quick --skip-opt supertext > supertext.sql Now when I try to restore the backup, the process just gets stuck. mysql -uuser -ppass dev_supertext < supertext.sql It get stuck w...

proper way of renaming / backing up files

i am constantly making changes to access and excel file macros and databases. what i usually do before i modify the file is i make a copy of the file and rename it to the filename_todaysdate.ext. is this the proper/safest way of doing things? ...

Ubuntu remote backup software like Windows Home Server

I'm running Ubuntu 10.04 Desktop on a headless machine to act as a server and a laptop dual-booting W7 and Ubuntu 10.04. I have a network setup so I can vnc, ssh from the laptop to the server. My question is what is some good software to run on the server that can perform scheduled full backups of clients within the network. It should b...

Backup SQL Server database

Hi. I can connect to remote SQL Server database and I want to create a local database copy on my system. How can I do it? When i try backup through Management studio I cannot copy backup file on my hard drive only on remote system hard drive. Copy database command also doesn't work because I have express version of SQL Server. And exp...