Stack Overflow
Stack Overflow

Questions tagged [database-backups]

database-backups are intended to preserve data by serializing database tables to a text format or exporting them to a binary format

database-backups are useful for archiving, upgrading, replicating, and migrating data

References

1580 questions
0
votes
3 answers

backup remote database locally

I have to backup my database in live server in certain interval of time. For this I created a batch file and scheduled it's execution using normal Windows' Schedular. I have called a php file in the batch file to perform the backup function. In the…
kushalbhaktajoshi
  • 4,640
  • 3
  • 22
  • 37
0
votes
1 answer

Any good example php scripts for backing up mssql table?

I am looking for a good php script that will create a backup of a few tables. However the method I want to use is, to create txt files that contain delete, reseed and insert statements to re-insert the backed up data. I already have seen how in…
crosenblum
  • 1,869
  • 5
  • 34
  • 57
0
votes
4 answers

Remote trigger a postgres database backup

I would like to backup my production database before and after running a database migration from my deploy server (not the database server) I've got a Postgresql 8.4 server sitting on a CentOS 5 machine. The website accessing the database is on a…
Michael
  • 482
  • 4
  • 9
0
votes
1 answer

Automatic MySQL backup on sharedhost

As I am not a coder so I should stop here but I am interested how far I could go to build an automatic SQL script. Case: A website is hosted on a shared host server which uses CPanel. The website use only one DB and one of the table is the log. Now…
TryHarder
  • 750
  • 1
  • 9
  • 22
0
votes
1 answer

SQL Server 2008 : how to back up database by query

I was studying SQL Server and I got a question about about creating queries for backing up database. I knew that SQL Server 2008 has function to create a .bak file. However, I am not sure if I can generate the queries for whole database. In SQL…
Dc Redwing
  • 1,681
  • 11
  • 32
  • 42
0
votes
1 answer

How to backup MySQL database from NSIS

I need to backup a MySQL database from an NSIS installer. I am missing something trivial in the scripts I tried: nsExec::Exec '"$mySqlDirectory\bin\mysqldump.exe" --user=$username --password=$password --routines $dbName --execute="source…
nawfal
  • 70,104
  • 56
  • 326
  • 368
0
votes
1 answer

Database Backup, drop transaction logs, shrink, drop nonclustered indexs, rebuild tables Fill factor 100%, compress

Let me start by saying I am a developer and I am just taking database backups for bug testing/fixing. I want to get the size of the backups I am taking down because at the moment it would be faster getting the backups posted to me than transfering…
user802599
  • 787
  • 2
  • 12
  • 35
0
votes
1 answer

SQL Server Backup (not restore!) error: The media set has 2 media families but only 1 are provided. All members must be provided

I am running into this error when trying to Backup a database: "The media set has 2 media families but only 1 are provided. All members must be provided." Please note this is on BACKUP not on restore. There are a lot of topics on this error for…
Vaal
  • 634
  • 7
  • 9
0
votes
1 answer

Azure Database Backup lost Comment

I am using the DAC framework's Import Export Service Client tool to export a BACPAC file from a SQL Database on Azure. But when I restore the BACPAC file to the Azure Database, it loses the comment of a Store Procedure or a View, which was initially…
CKyaw
  • 63
  • 1
  • 9
0
votes
1 answer

How do I back up a remote SQL Server database when it's not listed in SSMS's "Databases" section

I have a remote database on a shared host, and I can connect to it through SSMS if I specify the db name in advanced options. If I try to expand the "Databases" section of the object explorer, it times out and won't list the available databases. I…
Thomas Higginbotham
  • 1,662
  • 20
  • 25
0
votes
2 answers

Is it possible to export a database from SQL Server 2008 and import it into SQL Server 2005?

I need to move a database from SQL Server 2008 to 2005, did the backup format changed or can I import the exported DB in the SQL Server 2005? The database has tables, views and stored procedures, and it is not using any 2008 specific features. If…
CloudyMarble
  • 36,908
  • 70
  • 97
  • 130
0
votes
1 answer

Bypass Windows Server 2008 R2 UAC and run a script as Administrator

we are using Windows Server 2008 R2 O/S. We want to execute an script that stops sql server 2008 in the night time (Around 3 am) and copy all the data files. We want this process to be automatically done, as at 3 am no body would be available to run…
Shezi
  • 1,352
  • 4
  • 27
  • 51
0
votes
2 answers

How to backup my phpmyadmin correctly?

I have a problem with my server. Then I try to backup all database in my phpmyadmin.First, after login I choose DATABASE --> SELECT EXPORT --> THEN SELECT ALL DATABASE -> THEN DOING EXPORT. But, after i want to restore it into new phpmyadmin some…
nunu
  • 2,703
  • 9
  • 33
  • 55
0
votes
1 answer

how to create a scheduler to make an SQL Server DB back up?

I have created a database in SQL Server 2008 Express Edition. Can I write a program in VB.net express to take a daily backup at a specified time? What code do I need to write?
Red Swan
  • 15,157
  • 43
  • 156
  • 238
0
votes
7 answers

SQL Server 2005 Transaction Log will not Truncate

I have a database .mdf file that is 138 GB along with a transaction log file of 55 GB. The recovery model was set to Full (which it doesn't need to be). I ran a full backup of the database and the transaction log. The transaction log is still 55…
Tony Nelson
  • 3
  • 1
  • 1
  • 2
1 2 3
…
99
100