The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
117 views

Is it possible to export a database without its Users?

Is it possible to export a SQL Server database (data, structures) without its users ? If yes, is it possible using SSMS ?
-1
votes
1answer
171 views

Backup and Restore MySQL database [closed]

need backup MySQL 5.1 databse. Database is install on Windows Server 2003. I google it and I found many tools but I am little confuse what choose. My requirments are: Tool for backup must have a ...
0
votes
1answer
297 views

shell script won't work in cron

I have very smiple script to do a backup, and it is working fine when I run it from the command line, but I am having problems running it as cron job. My cron entry is this: (running it every minute ...
2
votes
1answer
548 views

Cleanup Backup Files without xp_cmdshell or maintenance plans

Background: We've got a backup script which needs xp_cmdshell to run. I decided that on new servers, we are not going to enable xp_cmdshell. I enabled xp_cmdshell when the job starts and turn it ...
10
votes
4answers
3k views

Should I backup and restore the `mysql` database?

In the process of creating an automated solution for backing up and restoring an entire MySQL server, I've come across the mysql database which seems to contain user accounts, permissions, metadata, ...
13
votes
6answers
1k views

Downtimeless MySQL backups on a budget

My current MySQL backup scenario is to replicate our db to a second server and run mysqldump on that server to remove any downtime from table or row locking. This is working well but costs $150 per ...
1
vote
4answers
4k views

Backup SQL Server DB to a remote drive

I am trying to backup a SQL Server database to another drive letter located on another network on another domain. The location has already been mapped to Z:\ and corresponds to \\10.98.76.6\Backups\. ...
0
votes
1answer
221 views

SQL Server 2005: Row in backup, missing in database

I've got a MS-SQL 2005 backup file. When I open with a text editor, despite being binary, I can see some information I want back. Nevertheless, when I restore the backup using MS-SQL studio, the row ...
3
votes
2answers
367 views

Oracle RAC failover backup procedure

We have Oracle 11gR2 RAC database on two nodes. We also have a RMAN backup script that works fine, using a recovery catalog database which is located in a town 20km from the data center. The script ...
0
votes
1answer
211 views

A utility to backup single tables on MSSQL?

Are there any Windows utilities that allow you back up single MSSQL tables? Having a lot or trouble finding any. I hear sqlbackupandftp is good, but as far as I can see, it doesn't back up single ...
1
vote
1answer
33 views

Error in moving Backup file

I have created a backup file by SQL query like this : BackUp [DBName] to disk=N'Backup path'. now i want to move it to another folder.but i recieve this error: Cannot copy 'Backup file ...
1
vote
3answers
171 views

What database backup utility should I use?

Can anyone recommend a database backup utility, free or paid? Ideally it will backup MSSQL & MySQL, but MSSQL only will suffice allow backup of single tables encrypt backups Many thanks
2
votes
1answer
286 views

Full, Differential and Log backups of databases, MSSQL an MYSQL

Best I give a back story so you get the full picture. I am in the process of setting up a new business, which hopefully will start in April 2012, and as such I am preparing every aspect of it. One ...
0
votes
1answer
2k views

Error in backup query of SQL Server

I have a database in SQL Server and I want to create backup from it to a shared folder. just one of the network users has permissions to access to this folder. I have written a code to log on this ...
1
vote
2answers
96 views

MySQL Backup Software

What are the best software packages for automated backups for MySQL? Even more important than how easy the backup process is would be the restore process. If I ever get in a bind with data ...
0
votes
2answers
353 views

Keeping two servers in sync - secondary server only to be booted for the backup, or in outage

I've just started a new Software Development job but I've basically been given loads of sysadmin stuff to do because the development team consists of only 2 people + the CTO. I've got pretty much zero ...
0
votes
4answers
427 views

Mysql Backup Solution

I would like to backup my mysql server remotely. I have three problems, and one requirement. I do not have enough space in my server. I can only keep one copy of backup in the local server I do ...
3
votes
3answers
1k views

SQL Server transaction log BACKUPS are very large

In SQL Server 2008 R2 I have a database that has full backups nightly and transaction log backups every ten minutes. The database is in full recovery model. The problem is that the backup files for ...
1
vote
1answer
325 views

will mysqldump lockout select or read only based queries

i have a large database to backup nightly and we currently do mysqldump on the master server which locks all inserts when dumping we use a master slave mysql setup with magento configured to send all ...
11
votes
3answers
1k views

Is this a valid backup strategy for MongoDB?

I've got a single dedicated server with a MongoDB database of around 10GB. I need to do daily backups, but I can't have downtime with the database. Is it possible to use a replica set on a single disk ...
0
votes
1answer
90 views

MySQL database backups to a local server

We have a backup system at the moment, but after a recent scare, we’d like another backup of just the MySQL databases, nightly, to a local server in our office. The databases are pretty big as it ...
1
vote
0answers
101 views

Effective backup and archive strategy for database and linked files

I am using Postgres to store a variety of application data for a webapp. Part of the application involves storing and retrieving user uploaded files. I am storing the files in the filesystem with ...
0
votes
1answer
76 views

Server restarted when I take database backup in SQL Server 2008?

I have 10 databases in my SQL Server 2008. If I take a database backup, 8 databases are working just fine. When I take database backup for the remaining two, at 50% of backup of process, the server ...
1
vote
0answers
1k views

How do deal with SQL Server transaction log corruption

We had a failure with our SQL Server log shipping job. sp_readerrorlog reported: Backup detected log corruption in database X. Context is Bad Middle Sector. LogFile: 2 'D:\Database\X_log.MDF' VLF ...
4
votes
2answers
574 views

Rackspace cloudserver backup options

I recently signed up with Rackspace to host some database servers. I've got two MySQL servers set up, and have a method to create backups (using the Percona Xtrabackup and innobackupex tools). I've ...
6
votes
3answers
1k views

Creating a *Consistent* *Online* MySQL Backup with InnoDB AND MyISAM tables

I just spent hours building a new database server to replace 2 failed servers from a mysqldump file created a month ago, then used my server's bin-logs to bring that mysqldump up to date. Now that I ...
0
votes
3answers
2k views

Is it possible to make a backup of a MS SQL database from a linux command line?

Is it possible to create a local backup file of a remote Microsoft SQL Server database, from a linux command line? I know I can use SQLCMD from a Windows command line, but is the same possible from a ...
0
votes
1answer
276 views

How Gmail and other Mailservice providers must be taking there DB Backups? [closed]

Being Anxious, I thought of asking this question in SO, which will certainly help in getting an idea for how the big DB carriers take their backups. How Gmail and other Mailservice providers must be ...
2
votes
4answers
486 views

Transferring PostgreSQL Database Between Servers

Is it possible to directly transfer a PostgreSQL database between two PostgreSQL servers? I've currently been setting up a "development" version of my production database by using pg_dump to ...
0
votes
1answer
200 views

backup berkeley db (java edition)

At the moment I am backing up my Berkley DB databases by taking hard copies of the log/db files periodically. The problem with this approach is that I run out of disk space quite quickly. Is there a ...
0
votes
1answer
429 views

Oracle 10g Failover Database - How to fail back?

I want to know how the failover database concept works after recovery. We have defined our application to connect to a backup database in case the production database fails. If this happens, then all ...
1
vote
2answers
149 views

Frequency of SQL Server full backups vs. diffs

I have a SQL Server located in a colo center. Currently, our database is about 100Gb. Log files average about 500Mb/day, and differential backups grow by a bit less than that. My current disaster ...
2
votes
1answer
326 views

SQL Server on EC2: What way do i set up the EBS

Good morning. We have a service with a SQL box on Amazon EC2 and, as suggested on this question, we are using EBS to store the data... the problem is, What is the best way to setup the storage? At ...
2
votes
1answer
220 views

Creating a small .bak file without indexes or excessive log

I recently was asked to ship a .bak file of our database to a client, and through reindexing all tables with a 100% fill factor (to make sure there were no empty slots), and resizing the transaction ...
1
vote
3answers
3k views

PostgreSQL automatic backup

I have been trying to set up a backup script on a windows server. I have used pgAgent (scheduling for pgAdmin), to run the backup script. No problems with the backup script. However, my jobs are not ...
2
votes
3answers
8k views

Incremental/Differential MySQL Backup using mysqldump

Are there any techniques to use mysqldump (or similar command) to make incremental or differential backups for MySQL?
1
vote
2answers
667 views

Using LVM Snapshot To Backup Database Servers

Could we use LVM snapshots to backup database servers? Or we can only use it for file system backups?
0
votes
1answer
53 views

Does SQL Agent need to be running in order to take manual SQL backups?

If we have a situation where SQL Agent fails to start, will we still be able to take a full manual SQL backup? I don't mean scheduled backups and maintenance plans, just plain Right Click > Tasks > ...
0
votes
2answers
34 views

SQL Server backup

I have Full-Backup-A Transaction-Log-Backup-A Transaction-Log-Backup-B (*) - I have to restore this point Full-Backup-B How to do it? It seems that the only way is Full-Backup-A ...
9
votes
2answers
9k views

How do I create a read only MySQL user for backup purposes with mysqldump?

I'm using the automysqlbackup script to dump my mysql databases, but I want to have a read-only user to do this with so that I'm not storing my root database password in a plaintext file. I've ...
1
vote
1answer
151 views

SQL Server 2005 SP3 Express Backups Incredibly Slow

I'm attempting to troubleshoot an issue with one of our customers who's using SQL Server 2005 SP3 Express to house their application data. The automatic backups that we perform when upgrading our ...
5
votes
2answers
2k views

pg_restore taking much longer than pg_dump

I am regularly saving and later restoring a smallish PostgreSQL database, which is used for testing. Its data is updated regularly as a result of tests, then a new dump must be made, and the dumps are ...
2
votes
1answer
987 views

How to backup/restore excluding filestream varbinary in SQL Server 2008?

There is an application used in a production site that uses SQL Server 2008 as its DBMS. The database schema uses Filestream Varbinary to save binary data on the filesystem instead of directly into ...
1
vote
1answer
761 views

Best open source Server backup utility with GUI?

I am looking for an open source/free server backup app with GUI (web based front end). Which app do you recommend? I search a little and came up with this list: 21 of the Best Free Linux Backup ...
3
votes
1answer
3k views

Is a MySQL stored procedure able to insert/update to a remote backup MySQL server?

Is it possible to create a MySQL stored procedure that can execute a given insert or update and then also have it connect to a 2nd server and run the same commands? I want to basically call one server ...
2
votes
2answers
2k views

Restoring a slave MySQL database from raw backups of master gives InnoDB tablespace errors

I have a master/slave replication setup where I use InnoDB and MyISAM tables in over 7000 databases that I want to copy from my master to the slave to restore replication. Both servers were running ...
-1
votes
2answers
157 views

Downloading Database dump from server

I have a mysql database on a server that is around 4 gb in size and I couldn't get it downloaded to my local machine. I tried getting a dump on the server, but the dump is not getting created probably ...
1
vote
1answer
137 views

Database backup using sql management studio 2008

I want to retrieve a script for a database that will include operations of creating database, creating tables, and insert all data. How can I achieve this using management studio 2008 please. I have ...
3
votes
1answer
79 views

Looking for automatic backup methods for sites

I need a suitable backup automation script that will run in PHP on my apache server. Some of my sites run Drupal. Which is the most suitable method to automatically backup both the code and the ...
1
vote
2answers
347 views

how to choose backup strategy?

I am DBA of a big online retail company. I am responsible for the availability of the company’s database. The size of this database is 28GB, and it handles an average of 120 transactions every minute. ...