Все вопросы: [backup]

303 вопросов

1
голосов
2ответов
1592 просмотров

Backup and Restore through the Entity Framework

I'm working with an SQL Server database with about 50 tables and plenty of relationships between those tables. I have already written a backup and restore function which will retrieve all data from the model, export it to XML which it could then import again into a clean database. But maintaining...

0
голосов
2ответов
623 просмотров

asp .net page to backup sql db

I'm trying to create an asp .net page to backup and download an mssql db from my remote host on a shared server. I tried using SMO to create a backup and save it the same folder as the .aspx page but it throws an access denied exception, I later found out that the sql server doesn't have permissi...

2
голосов
2ответов
4450 просмотров

How to create Cron job to backup MySQL and FTP backup to my backup server?

I want to setup a cron job to run so that it will automatically backup my MySQL database, while the database is running, and then FTP that backup to my backup server. I assume I can do this using a bash script. Anyone know of a good way to accomplish this? Thanks in advance.

0
голосов
1ответов
383 просмотров

backup reg hives

Using http://support.microsoft.com/kb/240184 I'm able to open SAM, SOFTWARE, SYSTEM reg hives, but I do not know the next step to get them copied in a different backup folder? I get Access Denied when I try to use BackupRead API. Any help is much appreciated!

1
голосов
4ответов
365 просмотров

Database maintenance with SSIS or T-SQL?

Is there any benefit to using SSIS over T-SQL to check integrity, defrag/rebuild indexes, and backup databases? Doesn't SSIS break down its internal tasks and containers into basic T-SQL statements anyways?

0
голосов
1ответов
285 просмотров

Rsync create new file on file size change

I need to backup (for debugging) some temporary files meanwhile a program running. I used to do it with rsync-ing the /var/tmp/someprogram directory with find . -iname 'blahblah' -exec rsync -someoptions $DESTdir, which works wonderful. Except the case of someone in some program (for which I don...

0
голосов
1ответов
294 просмотров

SQL Server Express backup restore not working for asp.net membership

I am backing up a SQL Server Express database and then restoring on another machine. For some reason the asp.net membership data is not getting transferred. Do I need to do something different. Does ASP.NET membership data not get backed up?

0
голосов
1ответов
2024 просмотров

VB.NET restore Backup file created on one server to another server

i am using SQL server express 2005 as an backend. I created a backup file programmatically.If i use same server , then it restore the data successfuly. however if we try to restore on different server, then it fails. and throw following message "The Backup set Holds a backup of a database other ...

3
голосов
1ответов
619 просмотров

How to programmatically access Gmail chats?

I want to add 'backupp Gmail chats' feature to Gmail Keeper at http://GmailKeeper.com but the chats are not available when accessing Gmail account through IMAP, any other ideas? Thank you.

0
голосов
3ответов
2763 просмотров

Automatically backup SQL Server database

I need to backup SQL Server database. Is it possible to do this automatically without human intervention at regular intervals? If so yes then please suggest me how to do it and I'm using SQL Server 2005 Express Edition.

3
голосов
5ответов
819 просмотров

Universal Database Backup / Extract Format

does there exist a universal database backup/extract format? I'll explain where I'm coming from: our application supports several database vendors, DB2, MsSql, MySql and Oracle. Currently when we request a backup from a customer they must make a full backup in the vendor specific format. We hav...

5
голосов
4ответов
4888 просмотров

C# Get the difference between two files and use it for incremental backup

I want to create my own incremental backup solution using C#. How can I obtain the difference between two files (version 1 and version 2 of ABC.TXT) and then update ABC.TXT version 1 with the difference? Would appreciate some hints! Thank you!

4
голосов
5ответов
2178 просмотров

How do I backup a MySQL database?

What do I have to consider when backing up a database with millions of entries? Are there any tools (maybe bundled with the MySQL server) that I could use?

4
голосов
4ответов
13735 просмотров

How to backup a Firebird database?

I am working on my first WinForms application with a Firebird database shared over a network. Now I wonder how should I ensure database backup and restoring? Up till now, my applications used embedded databases (SQLite), so I was sure that only my application accessed the database. The applicati...

0
голосов
1ответов
1702 просмотров

DB2 - LUW 8.2 Can you restore one tablespace from a full DB backup to a different server

In DB2 8.2 for LUW can you restore one tablespace to a 2nd server from a full database backup without having to restore the entire database? The database backup was taken when the system was up so log files are involved. I can provide further clarification if needed. Thanks, Dave

84
голосов
4ответов
224711 просмотров

How to decrypt an encrypted Apple iTunes iPhone backup?

I've been asked by a number of unfortunate iPhone users to help them restore data from their iTunes backups. This is easy when they are unencrypted, but not when they are encrypted, whether or not the password is known. As such, I'm trying to figure out the encryption scheme used on mddata and m...

2
голосов
3ответов
229 просмотров

Next log backup - will it contain any transactions?

I'm trying to efficiently determine if a log backup will contain any data. The best I have come up with is the following: DECLARE @last_lsn numeric(25,0) SELECT @last_lsn = last_log_backup_lsn FROM sys.database_recovery_status WHERE database_id = DB_ID() SELECT TOP 1 [Current LSN] FROM ::fn...

1
голосов
3ответов
1021 просмотров

PHP MySQL Backup script on IIS Server

Bit of a newbie, so please excuse the lack of terminology. . . . I have a PHP script to backup a MySQL database "dbjobs". I've tried nearly everything I can but can't get it to work. It works if I run the $command directly from the Command Prompt on the server, but everytime I try to run the PHP ...

0
голосов
1ответов
8146 просмотров

Export user rights into a SQL file for SQL Server

I would like to know if there is a query to export the user rights select insert grant and so on, to a SQL file. I managed to get the list of the Grants: Select * from INFORMATION_SCHEMA.TABLE_PRIVILEGES

1
голосов
2ответов
7800 просмотров

Unable to Recover Corrupt Oracle Datafile Block In SysAux

Oracle 10g on Suse 9.1 I'm looking after an Oracle DB. I have good SQL skills but I'm no DBA, (a diffence in job roles I have difficulty explaining to my non-IT savvy bosses!) I know enough to get Oracle up and running and put in place it's 'automatic' options for backup and optimisation then I ...

1
голосов
1ответов
8848 просмотров

Creating a batch file to back up a specified folder

I am actually pretty new to this batch file thing. I know it's important to know at least the basic commands. How do I do the following? Zipping a specified folder. Move the folder to another place. When zipping it, the ZIP file name will be the current date and if there is another zipped file...

15
голосов
3ответов
28831 просмотров

How to restore a database from C#

I have a SQL 2008 DB. I am running a form that backs that DB up, then tries to update it. If the update fails the idea is to restore that backup. Here is the code I am using to restore the backup. public void RestoreDatabase(String databaseName, String backUpFile, String serverName, String user...

0
голосов
4ответов
105 просмотров

Upgrading my Wordpress installation...click and pray?

I never know what to do when my Wordpress installation tells me there's an update available. I am using version 2.8 so whenever there is an update, all I have to do is click update, some magic happens behind the scenes, and it gets updated. But should I create backup files? And how? I have custom...

0
голосов
1ответов
2741 просмотров

Writing a file backup utility in C#

--BEGIN RANT-- ALL I want to do is copy the "Documents and Settings" folder to back it up in Windows Server 2003, so we can grab old files from it, as needed, easily, after I wipe the server to upgrade the OS to Windows Server 2008. BUT, I get errors about NTUSER being in use, etc., when I try t...

2
голосов
5ответов
7951 просмотров

Storing Svn Repositories folder on a Network drive

Does anyone store their Repositories folder on a network drive that's backed up? Is there any issues anyone's had with that as opposed to lets say keeping it stored on the host server that is running Subversion's C drive? We essentially want to put our repo on another network drive (different t...

3
голосов
16ответов
2428 просмотров

How Often Do you Back Up your Subversion Repository?

I wanted to know the frequency at which different shops are backing up their repositories. I have heard some even go to the extent of every 5 minutes to prevent from having to worry about after a restore, going through everyone's local Projects to find and merge in any uncommitted changes that a...

1
голосов
5ответов
672 просмотров

What's the best way to create a working copy of a SQL Server database?

I have a SQL database that I am currently converting from an Access database. One of the features of the Access database is to 'Copy DB' and is used when working in a 'dev' site - it copies all of the production data by physically copying the production file into the dev site. In this way, all ...

0
голосов
1ответов
1225 просмотров

MySQLdump results in lots of commented lines, no real content

I am trying to write a PHP program to automatically created backups of MySQL tables as sql files on the server: $backup = "$path/$tablename.sql"; $table = "mydbname.mytablename"; exec( sprintf( '/usr/bin/mysqldump --host=%s --user=%s --password=%s %s --quick --lock-tables --add-drop-tab...

1
голосов
1ответов
2041 просмотров

Oracle 10g Backup & Restore

Here is the scenario: Oracle 10g database running Windows Vista Business. This is a production/live db. Nightly backups (Whole database, online backup, ARCHIVELOG mode) moved to different machine on the network. Hard disk dies. Setup OS and Oracle 10g on the new hard drive. Oracle does not ha...

1
голосов
3ответов
9257 просмотров

Taking incremental backups of SQL Server 2008 Database

We are building an ASP.NET application (with C#.net as language) and will be hosting on Windows Server 2003 Operating System with SQL Server 2008 as database. We are planning to take the incremental database backups to a disk and use them to restore whenever there is a necessity. So would you p...