Click here to Skip to main content
15,899,679 members
Everything / Backup

Backup

backup

Great Reads

by Matteo Prosperi
This is the third post in the .NET libraries and the art of backward compatibility series.
by Uladzislau Baryshchyk
In this article, I'll show you how easy it is to move your MS SQL database to Amazon RDS cloud
by MJ Ferdous
SharePoint administrators need to run regular backups using PowerShell, the STSADM tool or in Central Administration. There is no "built in" way to automate these backups. Wouldn't it be great to devise a method to automated these jobs?.
by Mike Trank
Simple Daily SQL Server Database Backup Batch File

Latest Articles

by Peter Huber SG
How you should organise your backups in the time of cloud storage and write your own app for it
by Uladzislau Baryshchyk
In this article, I'll show you how easy it is to move your MS SQL database to Amazon RDS cloud
by Matteo Prosperi
This is the third post in the .NET libraries and the art of backward compatibility series.
by Uzi Granot
CopyTree is a Backup Utility implementing Backup Rotation Scheme. It is an open source Windows Forms Application written in C#. The utility was designed to perform backup of critical folders to multiple backup folders.

All Articles

Sort by Score

Backup 

10 Sep 2013 by Sergey Alexandrovich Kryukov
What you describe is not "Window raw data", this is disk raw data. It has nothing to do with Windows or Linux and has the same structure for both. There is nothing to "parse".And let me tell you that you are not saving any files. You are saving raw data which you can utilize if you have the...
27 Nov 2014 by OriginalGriff
Google is your friend: Be nice and visit him often. He can answer questions a lot more quickly than posting them here...A very quick search using a chunk of your question as the search term gave nearly 3/4 of a million hits: Google "automatic backup of SQL database"[^]The top "non-ad"...
7 May 2012 by Dhanamanikandan
You can set this value in web.config. For example, to change the timeout for one specific page: See...
20 Sep 2012 by Sergey Alexandrovich Kryukov
Please see my comment to the question.Now, has at least one version of your code survived somewhere? If so, back up all what you can, take as much of the source code you can save, and run away from SourceSafe as fast as you can, and never come back. Theoretically speaking, if someone insists...
15 Sep 2013 by CHill60
Because you have left a space after the -p you are essentially saying that the database does not have a password ... but it does - which is why the prompt then appears.It then tries to backup a database called password (or whatever your password is) instead of your actual db - hence a 0 byte...
13 Jan 2016 by OriginalGriff
Um.The first page when you google "Delta encoding" is Wiki: Delta encoding - Wikipedia, the free encyclopedia[^] which includes sample code in C.If you can't cope with implementing a trivial piece of code like that - which should be pretty obvious even if you don't specifically know anything...
26 Oct 2020 by Matteo Prosperi
This is the third post in the .NET libraries and the art of backward compatibility series.
20 Jul 2021 by Uladzislau Baryshchyk
In this article, I'll show you how easy it is to move your MS SQL database to Amazon RDS cloud
7 May 2012 by Ashish Sehajpal
try this :SqlCommand.Timeout = 1000;try changing your time out values for your command object depending upon the requirements. But this is not a good idea to rely on timeout. rather change your SP.
6 Aug 2012 by ArminA88
How to schedule a daily db restore on a windows shared hosting...As I figured out, with a rollback it cant be done, because I would have to create the whole db and fill the tables in the transaction, which isnt possible because a transaction doesnt allow multistate statements ... ......
1 Oct 2012 by OriginalGriff
Have a look here: Backing up an SQL Database in C#[^]
7 May 2013 by Maciej Los
The simplest way to backup/restore Access database is to use File.Copy[^] method ;)More about copying/restoring access databases: Copy a database object[^]Back up a database[^]I recommend you to compact and repair database[^] before copying operation.Please, see past...
16 Sep 2013 by CHill60
You need a space between "-u" and the username. NB there must NOT be a space between "-p" and the password (see your previous post)If you still get the error then check the permissions for the user id that you are using ... see this reference...
4 Nov 2013 by Sergey Alexandrovich Kryukov
This is something I would advice to buy a new disk or two and such a handy thing as an external disk dock which could be connected to a computer via USB 3.0, eSATA or at least USB 2.0. It's important to have at least a dual dock, to be able to connect two disks. Even if you upgrade some...
31 Jul 2014 by Bhatt Aniruddh
hi all,i want to get backup of folder on server from client PC.there is 5 pc attach with server. i want backup of particular folder of client PC on every 1 hour.is it possible in .net?How?Thanks
13 Oct 2014 by Maciej Los
If you want to backup your database, please read this:Create a Full Database Backup (SQL Server)[^]Use the Copy Database Wizard[^]Copy Databases with Backup and Restore[^]Although, i think you want to Move a Database Using Detach and Attach (Transact-SQL)[^]
1 Nov 2014 by Manas Bhardwaj
First, local does not mean anything. What it only signifies is the current system you are working on.I guess what you want to achieve is to backup a SQL database to another machine. A simple Google [^]search might give you a head start.
28 Mar 2015 by Sergey Alexandrovich Kryukov
Copying project files and being annoyed with that is more or less obvious indication of one more disturbing fact: you are not using any Revision Control system. If you don't you don't really do software development: you code asserts don't really belong to you, but to any random sleep of a hand...
15 Jul 2015 by Wendelius
This is based on a (faint) memory but if I remember correctly, when you define multiple devices, it means that the backup is distributed on those media. Based on that you should use only one media on the restore since you have all the data in one file.However I believe that it would be...
15 Nov 2015 by JatinKhimani
I want to implement Backup and Restore functionality for the user where they can take Backup of Certain data from the certain table and then they can restore it. I am working in desktop application in vb.net. Give you a scenario I have One Company Table in that Company id is primary Key ...
25 May 2016 by Mehdi Gholam
Read this : Creating and Restoring Database Backups With mysqldump and MySQL Enterprise Backup – Part 1 of 2 | MySQL Server Blog[^]
18 Apr 2019 by Richard MacCutchan
You already posted this question at What is DAC(.dac) file type ?[^]. And received advice on who to talk to for the answer. Please do not repost the same question.
15 Jun 2020 by Maciej Los
I'd suggest to use DotNetZip 1.13.8 (NuGet Gallery)[^] Quote: DotNetZip is a FAST, FREE class library and toolset for manipulating zip files. Use VB, C# or any .NET language to easily create, extract, or update zip files Usage: using (ZipFile...
3 May 2022 by OriginalGriff
Probably, it's the path. SQL runs as an engine that you communicate with - and that engine does not run under your user, it has its own user and its own permissions. So SQL can't access your files - "Users\will.sewell" is not accessible to the...
9 May 2023 by CHill60
The error is quite clear. You cannot restore a database that was backed up with a newer version of SQL Server onto a server running an older version. You will either need to upgrade your instance of SQL Server or find another instance that has...
13 Jan 2012 by MJ Ferdous
SharePoint administrators need to run regular backups using PowerShell, the STSADM tool or in Central Administration. There is no "built in" way to automate these backups. Wouldn't it be great to devise a method to automated these jobs?.
28 Mar 2012 by angel94
I want to know weather can i download different backup files using FTP in same browser using different windows.For ex,If i have two backup files in my ftp which belongs to two dates .can i download at same time in different windows simultaneously.will it effect anywhere else. I mean...
28 Mar 2012 by S@53K^S
Please go through the following site to learn about FTP...
7 May 2012 by Ashish Naval
Hi,I have an issue regarding execution of Stored procedure.Actually, I have a stored procedure for databases backup in which I have implemented Cursors for each database to be backed up in that server. For execution of database backup, I have to just pass a parameter in that SP i.e. Folder...
23 Jun 2012 by elidrissi.amine1
I executed the following instructionBACKUP DATABASE jpa TO DISK = 'G:\backJpa.bak'In the SQL server management studio of my home machine which is connected via local network to the sql server of my company.Note that 'G:\backJpa.bak' references the path that exists in my machine not in the...
23 Jun 2012 by Sandeep Mewara
"the specified path isn't found" It's pretty clear that the issue is with path provided. The way you are trying to access it and then backup is not working. Verify the location of database being mapped correctly to the path given and then verify the path given for saving it is accessible.
4 Sep 2012 by ArminA88
A full backup would have to be done
20 Sep 2012 by talk2robert
Hello All,I have an .ssa file from SourceSafe i need to restore/open but SourceSafe says it might be corrupt and refuses to open it . Does anyone now how I might repair open this file?Just to clarify, it's not the SourceSafe database files I'm trying to repair, but the backup file...
3 Oct 2012 by footballpardeep
con.ConnectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=Database1;Integrated Security=True;User Instance=True"; con.Open(); cmd.CommandText = @"restore database Database1 from disk ='d:\\MyDatabaseBackup.bak'"; cmd.Connection = con; ...
2 Oct 2012 by footballpardeep
User of my application has created the backup file of the database.Now i want that when the user resinstall my application(At new Operating System),the backup should restore to the Application folder of my application.How to do it plz tell me.
3 Oct 2012 by Kiran Susarla
You can use the T-SQL Restore statement like shown belowRestore DATABASE databaseNameFROM DISK='backup file path'WITH NORECOVERY,MOVE 'DataFile logical name' TO 'FileSystemPath',MOVE 'LogFile logical name' TO 'FileSystemPath'
3 Oct 2012 by Reza Ahmadi
Hi, Take a look at this post which is one of the million posts in this regard:SQL Server 2005 Database Backup and Restore using C# and .NET 2.0[^]Hope it helps,Cheers
20 Oct 2012 by bcsilent
Hi, I have written the code for the backups, but I got an error? SqlCommand cmd = new SqlCommand(); cmd.Connection = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbcn.mdf;Integrated Security=True;Connect Timeout=10;User Instance=True"); ...
20 Oct 2012 by Shahriar Iqbal Chowdhury/Galib
hi,try this solution belowhttp://www.mssqltips.com/sqlservertip/1849/backup-and-restore-sql-server-databases-programmatically-with-smo/[^]It shows how to take backup programmatically.
20 Dec 2012 by gssajith87
In Vshadow.exe , when trying to create a shadow copy, there is procedure that excludes Writer Components from the shadow copy.Is this exclusion of writer component a necessary step during a backup operation that relies on Volume Shadow Copy Service ? What are the effects if this process of...
4 Jan 2013 by Sandeep Mewara
This is not a well framed question! We cannot work out what you are trying to do/ask from the post. Further, it does not work like this here.Here is what is expected of enquirers:1. TRY first what you want to do! You may find that it's not that hard.2. Formulate what was done by you...
24 Jan 2013 by Thé Dèvíl 2013
I have a scenario: I am downloading something through a program which when closed will start-over the entire download progress should I restart it. A situation happening in a desktop with the possibility of losing power in raid.Windows (perhaps the rest as well) has power-saving modes,...
12 Feb 2013 by bharati Mardekar
Hello All,we are developing a web based application in asp.net using c#.we are in a need of creating database backup file , which now gets saved in directory but we want it to be saved to the online server.need help in this , helpful answers will be rewarded.
12 Feb 2013 by Anurag Sinha V
Hi there,I dont have much info but i guess the below links might help you.Have a look.http://stackoverflow.com/questions/1268766/writing-file-to-web-server-asp-net[^]http://stackoverflow.com/questions/5816699/file-uploading-using-server-mappath-and-fileupload-saveas[^]Happy...
18 Mar 2013 by veena nair
How can i create a C# application that help to backup database from a local meachine and restoring it to a remote sql server automatically... please help i am in a trouble......thanks in advance
18 Mar 2013 by Dineshshp
You can not backup and restore database from local machine to server,but you can create a task on server that can backup and restore database on server.okyeeeeee...if you are familier with sql commands you can user BACKUP DATABASE & RESTORE DATABASE commands to complete these task...
19 Mar 2013 by veena nair
Hello experts,I am trying to develop a program in c#. What i want to do is to select a SQL database backup from my computer(Eg test.bak)and want to restore it in a SQL managment studio installed in a remote computer... please help me. if you can share any source code please it with me....
19 Mar 2013 by josh-jw
check this linkhttp://stackoverflow.com/questions/13396027/restoring-a-database-from-bak-file-on-another-machine[^]
29 Apr 2013 by ♥…ЯҠ…♥
Hi footballpardeep,Why you didnt ask google about it? I hope this link[^] would help you a bit.Regards,RK
1 May 2013 by Vondersmith
We have a legacy application that runs on an AS/400. One of the applications we have allows users to key a batch of transactions and then post them to a ledger. In the AS/400 application we would backup the data that was being posted and the ledger files prior to the post. Then if something...
1 May 2013 by CHill60
Firstly into using tranactions - http://www.sqlteam.com/article/introduction-to-transactions[^] and the microsoft documentation here http://msdn.microsoft.com/en-us/library/ms174377.aspx[^]However, you seem to be implying that the user can make this choice for themselves (compared to...
19 May 2013 by gyaan86
I have a database in SQL Server 2005, which i want to backup but i want to make it safer from other users. So is it possible to set authentication restriction while backing up the database. When any user tries to restore it, he/she will need to provide user id and password to restore it. How to...
19 May 2013 by Mehdi Gholam
The best you can do is put a password on your backup files : http://www.mssqltips.com/sqlservertip/1108/using-passwords-with-sql-server-database-backup-files/[^]
25 May 2013 by Dave Kreskowiak
You don't do this in your code. This would normally be done as a scheduled job in SQL Server. Create the job in SQL Server Manager and you're done. No code required.
5 Jun 2013 by mehdi rahimzade
hi my friend i need to create back up from my operating system(windows or Linux or ...) and restore this when OS not work well.What can I do?What language should I use?i can use C# or use ActiveX or component to do this?thanks
5 Jun 2013 by Bernhard Hiller
For that purpose, you have to use a tool which can read a hard disk partition physically, i.e. sectot by sector. With Linux, dd can do so. There are some tools available which start from CD and store such a backup to another drive or a location in the network.With C# or ActiveX, you won't be...
5 Jun 2013 by mehdi rahimzade
Can you provide an example?With other languages ​​such as C++ can do that?
10 Sep 2013 by Jameswilliam
I am working on a backup application using C/C++. I have backed up all the data from a Windows volume snapshot(client is Windows) and has send it to our server which is a linux machine. The data that I have backed up and send is all the sectors and raw data. Now at the server side(linux machine)...
10 Sep 2013 by Philippe Mori
I am not sure that you want to do that.NTFS structure is far more complicated than FAT and also changes from version to version. Why not do an usual file copy?If the copy is for restauration purpose, then you should buy an existing software done for that purpose.Also if you do a...
15 Sep 2013 by Member 10187970
Good day!I would like to ask what's wrong with my code in backing up my mysql database. Here's my code:Process.Start("C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe", "-u username -p password db -r """ & txtpath.Text & "\backup.sql"" ")whenever I use it, I get a 0 MB...
8 Oct 2013 by indrajeet jadhav
http://support.microsoft.com/kb/2019698[^]2.http://lakkireddymadhu.wordpress.com/2013/03/01/scheduling-automated-backup-using-sql-server-2008/[^]
11 Nov 2013 by amltzy
The solution 1 is right.You can do Incremental Backup or Differential Backup.I used AOMEI Backupper instead of NOVABACKUP.It is only a matter of different personal taste.I think Backupper can compress files better.Good luck
12 Dec 2013 by Rachel Jia
Check out this article: Automated Source Safe Backups[^]
6 Feb 2014 by JOE Heart Under Blade
On December last year i have doing Backup Database using MYSQL Dump. During i backup there is no problem and i can backup my database as mySQL Dup successfully. This Month i try to Restore that database using Restore Database From SQL Dump and error has occurred in the middle of the...
11 Mar 2014 by agent_kruger
I am developing a software to take backup every 3 days on a remote server but have no idea how to send the files to a remote server connected via. Internet (Not intanet) PROGRAMITICALLY. Can somebody give me a clue how to start or how to achieve this.Thanks in advance
17 May 2014 by Member 10800202
How do I create a service control in c# to backup of the sql express automatically with the specified schedule ?
17 May 2014 by Mehdi Gholam
You don't need to create anything, read this : How to schedule and automate backups of SQL Server databases in SQL Server Express[^]
7 Jul 2014 by vezo11
Hi,if i have create backup for Microsoft SQL Server 2008 R1 from Microsoft SQL Server 2008 R2? Can i only convert a bak file? Please do not provide a solution to create a script.Thanks!
7 Jul 2014 by sankarsan parida
No, In this particular case, SQL Server Management Studio is telling me that when SQL Server attempted to restore the backup, it realized that the backup was from SQL Server 2008R2 but I was restoring to SQL Server 2008. As a result, the restore failed.You can’t restore a backup from a newer...
7 Jul 2014 by OriginalGriff
No. If you cretae a "proper backup" file for R2, then you can't restore it to R1 - you can go the other way, but you can't "downgrade" the data as R1 doesn't know anything about R2 (understandably)So despite this: "Please do not provide a solution to create a script." I'm going to: your only...
14 Jul 2014 by vezo11
Only way is to create scripts (you can create script for 2008 or older version). During the generation of scripts you can choose between only schema, schema+data, only data...
26 Jul 2014 by saeid2010
Hi all.What is T-Sql script for backup maintenance plan? I want to manage that from app.actually, i want to Configure Automatic Backups with Task Scheduler with T-Sql script from app .Thanks.
26 Jul 2014 by Abhinav S
try these links -Create a Full Database Backup (SQL Server)[^]Simple script to backup all SQL Server databases[^]SQL Server BACKUP DATABASE command [^]
27 Jul 2014 by saeid2010
My question solved.plz see http://stackoverflow.com/questions/24978600/t-sql-script-for-sql-server-backup-maintenance-plan[^]
31 Jul 2014 by Mehdi Gholam
Try using this instead of writing your own (with all the associated complexities): http://www.bittorrent.com/sync[^]
21 Oct 2014 by CHill60
See response from Max Meng on this MS TechNet link[^]Be aware that if your question starts to attract spam answers you will probably also be reported for abuse, so if you didn't intend that, then best get rid of this post
1 Nov 2014 by Member239258
How to backup Sql Database from Remote Server to Local Machine.Please help.
24 Jun 2019 by forccyy
Hi,I have one DB backup file. file type : filefile extension : .fileI want to restore data from above mentioned file. How can I do it? I only know restoring db from .bak file but how to do it from file where type = file.
8 Dec 2014 by /\jmot
To restore a backup from a deviceAfter connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.Expand Databases, and, depending on the database, either select a user database or expand System...
8 Dec 2014 by OriginalGriff
We can't tell - we have no idea what created the file in the first place.Presumably, you created the backup - so you know what tool you used to create it. So use the matching tool! The file type / extension isn't that relevant: the "file type" is a human readable description based on the...
26 Apr 2016 by Yesudass Moses
How can I do incremental backup with Histories using wbadmin in Windows Server 2008 R2. I want to restore it back for a particular date later. More, Is there any provision to keep history only for last 30 days and delete histories before that ?
4 Feb 2015 by SreeDBA
Hi,I had two servers(SQL 2005) A and B. B is Production server and A is DR. I want to take backups for B server databases from A server. We can not create any maintenance plans or jobs in B production server. We can create any jobs in DR server to take backups for Prod server. Is it...
14 Mar 2015 by Member 9308808
I keep getting this error:Exception calling "SqlBackup" with "1" argument(s): "Backup failed for Server 'MyServer'. "At C:\Users\hp1\Desktop\scripts\backup.ps1:28 char:5+ $smoBackup.SqlBackup($server)+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified:...
15 Mar 2015 by Member 9308808
I found the problem. It had to do with permissions to the destination folder for the SQL Server Service Account. A common problem when backing up is checking that the SQL Server Service Account has the correct permissions to access the destination. PowerShell is just submitting T-SQL to SQL...
24 Mar 2015 by Silver Bel
I have a code for transferring files using winscp, I want to log all files that was transferred. The problem is, when the hierarchy gets deeper(folders/files under subfolders). The logs prints multiple times) Example below:I want to transfer "1.1.1.txt" to the remote server in folder "New...
15 Apr 2015 by Gennady46
Hi, is it possible with C++ to backup the whole system image of your PC, meaning not just coping files, but the whole operating system, with all its programs and files, and to schedule to do it like once a week, including all the drives specified, I have external HD 4TB, Seagate model (which...
9 Jun 2015 by Yashwanth R
Hi, I have created a Virtual Machine in Windows Azure account using trial version. I need to take back up of Virtual Machine, which i have successfully done using backup agent and even using backup vault in azure portal. But is it possible to take VM backup from windows Azure and...
10 Jun 2015 by Kornfeld Eliyahu Peter
No.It is possible only the other way around - you can backup your local storage to your Azure account...
13 Jun 2015 by OriginalGriff
Talk to Acronis. The software isn't cheap, so their technical support is the first place to try - you are paying for it anyway!
20 Jun 2015 by saghar1365
i have install my application in 2 different systems.users may need backup some optional data from one system and transfer them on the other system. i really don't know how i can get backup of my all database but with user selected data?
23 Jun 2015 by VishwaKL
Here is the link which explain about the backup you can refer and try something which you required. SQL Back Up[^]
6 Jul 2015 by Mike Trank
Simple Daily SQL Server Database Backup Batch File
15 Jul 2015 by Sander Rossel
Hi all,I'm having a little trouble restoring a database backup.I've got the following queries for backing up my database:-- Full backup every night at 01:00.DECLARE @FileName VARCHAR(256)SET @FileName = 'C:\Backups\mydb_backup_' + CONVERT(VARCHAR(8), CURRENT_TIMESTAMP, 112) +...
29 Dec 2015 by 2irfanshaikh
This link may help youC# Get the difference between two files and use it for incremental backup - Stack Overflow[^]
6 Jan 2016 by _Asif_
There is no incremental Backup in SQL Server, read this Does SQL Server have incremental data backups? | SQL Server Questions Answered[^]. However Differential Backups support is present. Read* SQL Server: Understanding SQL Server Backups[^]* Differential Backups (SQL Server)[^]
18 Jan 2016 by Kasthuri Gunabalasingam
I m trying to backup Folders from local drive to Dropbox using Duplicati command in Command prompt. (Backup should be Incremental)C:\Users\Desktop\Office_Works\Duplicati\Duplicati 1.3.4\Duplicati>Duplicati.CommandLine.exe backup a https://www.dropbox.com/Enter passphrase: **Confirm...
2 Mar 2016 by User-11630313
i am using postgresql database for web application.i want to backup my application database how can i do?thank you What I have tried:I tried backup in postgresql tools but iam getting error like this --format custom --blobs --encoding UTF8 --verbose --file...
2 Mar 2016 by Maciej Los
I'd suggest to read Richard MacCutchan[^] comment to the question and the documentation[^].Quote: If you have problems running pg_dump, make sure you are able to select information from the database using, for example, psql[^]. Also, any default connection settings and environment variables...
26 Apr 2016 by Member 10218191
yes you can but it is not a dircet way.you can set system restore on on the HDD you you are backing up to.if you set the a bigger space on destination Hdd, you can hold more versions of your backup images.i you need more description, i can say more about