Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.

learn more… | top users | synonyms

2
votes
1answer
142 views

Availability Strategies in MS SQL Server 2008

I need some assistance in developing a backup strategy for my SQL Server deployments. Currently I have two classes of customer: Hosted customers, whose data is housed in our datacenter, and On ...
1
vote
3answers
2k views

Transaction log for SQL Server is too big

I have a database that has a 33 gb transaction log. It is caused by the fact that the database is in full recovery mode has been used for over 5 years prior to the first backup. I want to truncate ...
1
vote
4answers
291 views

Database backups

I have 10gb RDBMS (SQL Server). I would like to back it up as often as possible, but it seems that I will need an awful lot of space to make this happen on the order of several times per day. How ...
1
vote
2answers
466 views

restore could not start database

Restore failed for Server 'servername'. (Microsoft.SqlServer.SmoExtended) System.Data.SqlClient.SqlError: RESTORE could not start database 'ECP'. (Microsoft.SqlServer.Smo) The database is ...
1
vote
4answers
4k views

How do I archive and restore selected tables using SQL Server?

How do I archive and restore selected tables using SQL Server?
1
vote
2answers
196 views

T-SQL script to perform a compressed backup with maximum compression level [duplicate]

I have a database with full backup of almost 2GB. When I perform a full backup (without compression) and then compress it with winrar it become 140MB, but when I backup WITH COMPRESSION syntax the ...
1
vote
3answers
524 views

Restore database with zero size log file [duplicate]

SQL Server backups contain meta-data about the size of the original log (LDF) file. So if you backup a database that has a 5GB LDF file, when you restore it, you will get an (empty) 5GB LDF file. ...
1
vote
2answers
107 views

How to backup databases to ensure data recovery

I have 15 customer databases that have minimum replication at different sites. I currently do nightly back-ups and transfer the database back-up nightly to our main server via 7zip. We recently had ...
1
vote
2answers
316 views

SQL server 2005 SP4 differential backup is failing

We have an SQL server 2005 with SP4, x86. When we attempt to take the differential backup, we are getting the following error message. Cannot perform a differential backup for database "ABCD", ...
1
vote
2answers
183 views

What are the primary architectural differences between the backup formats of some of the more common RDBMS' and what advantage do they serve?

Of the systems with which I am familiar, I have noticed that SQL Server's native database backup format is binary and proprietary. PostgreSQL and MySQL allow for a simpler approach, dumping the ...
1
vote
3answers
100 views

Is bulk-logged recovery model ever a good choice if point-in-time restore is not needed?

Is the Bulk-Logged recovery model in SQL Server ever preferable to Simple if point-in-time restore is never needed? I have read many articles about transaction log models, but cannot find a clear ...
1
vote
1answer
494 views

How to flush SQL Server database from RAM to hard disk?

As part of the nightly maintenance plan, my working MS SQL Server 2012 databases are backup-ed with options of simple recovery and full backup. Transaction log is not backup-ed. Also, at nights the ...
1
vote
1answer
324 views

Restore SQL Server 2000 Database in use

I need to restore a SQL Server 2000 database to a backup of about 2 days ago. I have just backed it up and have tried to restore it, but it says it is in use. What is the best way to find out who is ...
1
vote
1answer
1k views

Does mysqldump -all-databases include all objects

Does mysqldump -all-databases include all objects ? I have to migrate all databases to new server.
1
vote
4answers
848 views

Automated SQL backup on a timely fashion, & cleaup the database for the backed up data

I need to back up SQL database (historian), on a timely fashion, and then clean up the database by removing the backed up data. I am using MS SQL 2008 (R2), on a Windows XP machine. The biggest issue ...
1
vote
1answer
466 views

Two databases of same size, backups sizes are very different

This is not a big problem for me, but still, I would like to understand what is happening here. I have two databases on my SQL Server 2008 (10.00.1600) - they are restored from the same backup (and ...
1
vote
1answer
188 views

Restoring a differential backup in SQL server 2005

I have created a full back up of my database by executing the line below in my application: Dim Query As String = "backup database Ari to disk='G:\Documents and Settings\i\Desktop\BKAR\" & ...
1
vote
2answers
1k views

Differential backups in SQL Server 2008 R2

I created a maintenance plan to backup all user databases (full) and set them to expire after three days. This has proved to be cost inefficient in regards to disk space so I want to switch to ...
1
vote
3answers
159 views

Where can I learn about MySQL master/slave, master/master, or clustering setups?

What are the best resources you've read or watched about setting up master/slave or clustering for database replication? I don't know much about this. I have a database that is getting rather large ...
1
vote
1answer
1k views

SQL Server: Simple database restore with overwrite

What I'm trying to do is backup one of our production databases and restore them as our dev database (overwriting what's been there). That's how I back up: backup database [authfx] to disk = ...
1
vote
4answers
5k views

Taking a backup of a single table in the SQL Server

I know how to take a backup of a database in SQL Server and restore it. But how can I take a backup of a single table, and then restore it? Is it possible? I have a database with two different names ...
1
vote
2answers
5k views

How to take Oracle backup and restore?

I am coming from SQL Server background where SQL Server studio has a very easy way of taking database backup and then doing a restore. I have been using Oracle 11G express edition for past couple of ...
1
vote
2answers
491 views

Oracle Databases - need to export nightly for backup/DR purposes

I know nothing about Oracle databases, so if my question's path seems odd, feel free to tell me the right way to do things. I have 2 ways I see currently that I can backup a server running 3 Oracle ...
1
vote
4answers
205 views

Database growth causing issues sending backup over network

We take a full database backup on our primary SQL Server, and send that file over our network to a remote site where it is recovered on a backup SQL Server. We use this backup database for slow ...
1
vote
2answers
118 views

Backup of database X on SQL Server 2008 on server A - restore to SQL Server 2012 database Y on server B

I want to copy a SQL Server 2008 database to SQL Server 2012 with a different database name. Took a backup of 'production' and copied it to the SQL Server 2012 machine. Created a new SQL Server 2012 ...
1
vote
2answers
3k views

How to Fix log_reuse_wait_desc=LOG_BACKUP? LOG Backup not possible

I checked sys.databases to find out which databases need LOG backups. It surprised me that I had quite a few where log_reuse_wait_desc=LOG_BACKUP meaning, the JOB I have set up to run LOG backups on ...
1
vote
5answers
1k views

Mirroring vs. Log Shipping

The software company I work for is planning to migrating our infrastructure into the cloud. Our current focus is to find the best database replication method. Current Servers: SQL Server 2008 SE - ...
1
vote
2answers
1k views

How to backup to local drive and network drive simultaneously?

I can backup to a local drive and mirror: BACKUP DATABASE [xxx] TO DISK = N'XXXX.bak' MIRROR TO DISK =N'Network path \XXX.bak' WITH INIT --directly to network drive BACKUP DATABASE [xxx] TO DISK ...
1
vote
1answer
112 views

Does the SQL Server Backup Database Command also backup views from a Database?

I have a backup job (SQL Server Agent job) which will iterate through all of our SQL Server databases in SSMS, invoke the BACKUP DATABASE command to create a .bak file on a different server. This ...
1
vote
3answers
4k views

There is any option for mysqldump to ignore databases for backup in mysql

we have 40 databases in our server. we want to take 36 databases backup using mysqldump. how can i ignore remainig 4 databases in mysqldump command. there is any option for mysqldump to ignore ...
1
vote
1answer
1k views

automating a database backup, restore and stored proc call

How do I create a process that will: backup Database A restore it as Database X (needs to be definable) then run a stored procedure against Database X. shrink and truncate its log file. Anybody ...
1
vote
2answers
77 views

Backing up my SQL Server System Databases

I'm trying to create a recurring scheduled job to fully backup the master, msdb and model databases, I'm using the Maintenance Plans for SQL Server 2008 R2, in the "Specific Databases to choose from ...
1
vote
1answer
101 views

Is it possible to change the drive that Microsoft DPM backs up to?

A while ago our sysops guys created a 15 minute transaction log backup schedule using Microsoft DPM. We often have an issue where there won't be enough space on the Log drive to perform a backup ...
1
vote
3answers
182 views

xtrabackup prepare - after dump or before restore?

i have doubts about xtrabackup --apply-log. is there any difference when use it? should it be done right after dump or before restore (even few months later)? seems stupid, but maybe i missing ...
1
vote
1answer
130 views

Should my Postgres backup server be as beefy (IO, processor, RAM) as my master?

I've set up a Postgres database on a server with 2 CPU cores, 4GB of RAM and an SSD volume (on top of RAID 10 of course). This is our (sort-of) "beefy" production database server (I can easily add ...
1
vote
2answers
1k views

Shrinking log files with SMO

I know I can use the following t-SQL to shrink a log file: BACKUP LOG db1 TO DISK = '\\server\share\db1_log1.trn'; DBCC ShrinkFile([db1_log], 0); How do I do the same with SMO? I tried: $server = ...
1
vote
1answer
324 views

Postgresql: Difference between pg_dump and backup/restore?

Don't they essentially do the same thing by storing all the data in a file and dumping it into another database? Is it that pg_dump just adds the data on to whatever is already there and restore ...
1
vote
2answers
162 views

Move named instance to another server

To be honest I'm not a DBA expert. I get asked by one of my clients in terms of moving a SQL Server development instance that is stored in the production server (source) to another server ...
1
vote
4answers
3k views

Restore backup fails - not enough disk space [duplicate]

I have a backup that's about 6Gb. It's a "light" backup of the original (with the log tables purged), which is about 14Gb. I try to restore the backup on my SQL Express local server. It fails with a ...
1
vote
1answer
244 views

Questions about PostgreSQL backup/restores

I've inherited a large PostgreSQL 8.4.7 database that is currently not being backup at all. The database itself I believe is around 100GB, I've been reading about the different methods to backup this ...
1
vote
1answer
1k views

Oracle backup with RMAN Options?

I'm trying to learn RMAN but getting confused everytime I read Oracle docs! Can someone help me what are the differences and when to use the following? BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT ...
1
vote
2answers
1k views

Backup of Postgres database

I want to create a backup of my database in Postgres. I'm using pgAdmin. on my database I have clicked right button of mouse after that I've selected the "Create a backup of database" After that ...
1
vote
1answer
66 views

How do I determine if a database restore file should be restored to the database based on backupset?

I have a production database that is fully backed up nightly and incrementally backed up hourly. On our backup machine, we have the differential backups and full backups restored ion a regular basis ...
1
vote
1answer
2k views

Restore Oracle database from cold backup files

I have cold backup files for an oracle database. Can someone tell me a step by step procedure on how to restore the database on my machine.I am using Oracle 11g
1
vote
1answer
82 views

Back up and restore to main system

I have a software system running in my office with MS SQL Server in back end.I want to backup the database daily and delete all data from database so that only one-day data will be in the database at ...
1
vote
1answer
458 views

Oracle Backup and Recovery

My backed up archivelog file format is 'al_%U'. During recovery it shows the following error: RMAN-06054: media recovery requesting unknown log: thread 1 seq 17 lowscn 671075 How to determine which ...
1
vote
1answer
43 views

Fix transaction log file after database update

I have a databases that are regularly (monthly) updated. An update includes a lot of new or changed T-SQP procedures, functions, indexes creation, etc. A database X has transaction log file with the ...
1
vote
1answer
67 views

MS SQL Server 2012: once a day full replication (automatic backup/restore) for reporting

Our company is w/o a DBA, and it has fallen on me (a complete DB noob) to handle some critical database tasks. I'm looking for the best solution for us to be able to "copy" a full database to another ...
1
vote
1answer
107 views

Decrease WAL file size for backup

I'm setting up a backup strategy based on WAL files archiving and transmission via rsync. As DB activity will propably be very low (less than 100 inserts/updates/deletes per day), at least in the ...
1
vote
1answer
69 views

What synchronizes two delayed replicas, which is part of the replica set, included in sharded cluster?

Please take a look at my mongodb map at http://postimg.org/image/krzvmep4d/ What synchronizes two delayed replicas, which is part of the replica set, included in sharded cluster? How can I use my ...