Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.
0
votes
1answer
24 views
help with best practice of merging sql databases
Bad news, our website server (windows 2003) crashed because of dead RAID controller.
Luckily few hours later our backup server was up and website was live again.
Hopefully tomorrow our original ...
1
vote
2answers
42 views
How to backup IBM DB2 Database online?
I tried to backup the IBM DB2 (LUW) Database using this command:
./db2 backup database DBEMP to /home/user1/db2bkup
But I got this message:
SQL1035N The database is currently in use. ...
-1
votes
1answer
55 views
How to merge data from 2 databases [duplicate]
I have a SQL-Server database that crashed while I was away on vacation. All info from 5/2/13 is missing from our current database because my replacement implemented a back-up of the database from ...
0
votes
1answer
23 views
passing --single-transaction in mysqldump command line tool
I'm using MySQL GUI tool to backup my innodb database and I use the option '--single-transaction' to get a consistent copy as backup.
I have however, noticed that if I backup using command line ...
0
votes
0answers
20 views
'Offline' MySQL backup - server not starting
The MySQL server is no longer starting because the partition is too full. The issue seems to be ibdata (40GB). I wanted to follow these instructions (at 'InnoDB Infrastructure Cleanup')
Now I already ...
1
vote
3answers
48 views
SQL Server - 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. ...
2
votes
1answer
29 views
To make a LVM backup of a MySQL database, would I have to reduce the logical volume size?
I am trying to learn how to do a Ubuntu LVM backup of a MySQL database.
For this test I installed a fresh copy of Ubuntu 12.04.2 LTS on a new box, along with MySQL 5.5. The box has one hard drive. ...
1
vote
2answers
62 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
1answer
50 views
How do I refresh SQL server cross database references after a database is reattached with a different name? (Are there hidden synonyms?)
I have 2 seperate SQL databases on the same SQL instance. Database1 references tables on Database2 in its views and stored procedures. Everything was working fine until we had to create a fresh ...
1
vote
4answers
140 views
Daily and Differential Backups
Is there a program with which I can create daily MySQL, PostgreSQL and MariaDB backups with these requirements:
The first time, make a full backup.
The second time, only the changes since the last ...
0
votes
0answers
36 views
Backup daily for MySQL, MariaDB or PostgreSQL [duplicate]
Good day:
I wonder if there is a program with which I can create daily backups with these requirements:
The first time, make a full backup.
The second time, only the changes since the last backup, ...
1
vote
2answers
69 views
Is it possible to backup an sql database if it's status is not online?
We have an sql job which backs up all database in the sql server every night(excluding tempdb) whose state is 0 (online), but due to some reason it didn't back msdb. So the issue is at that time msdb ...
0
votes
1answer
19 views
OK to put temp tablespace on volatile storage or to omit it from backups? (Postgresql)
I would intuit that it's fine, but I just want to make sure there are
no gotchas from a recovery point of view:
If I were to lose my temp tablespace upon system crash, would this
prevent proper crash ...
1
vote
1answer
21 views
xtrabackup backup grants?
I'm using MySQL 5.5 + Opensuse 12.3 .
After face an issue with mysqldump (appear be a bug with OpenSuse Mysql distribution) I have looking for others backup solution.
I found the xtrabackup from ...
0
votes
0answers
28 views
Should I keep pg_xlog on the same disk as data if using disk snapshotting?
We're running on EBS volumes on EC2. We're interested in leveraging
EBS snapshotting for backups. However, does this mean we'd need to
ensure our pg_xlog is on the same EBS volume as our data?
(I ...
1
vote
1answer
88 views
how to create a database backup in network drive along with local drive in sql server 2012 Standard Edition
--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 = N'Network path ...
0
votes
1answer
27 views
SQL server dataloss restore
I have done an incorrect update in my DB and hence I restored the DB with a backup from the previous day. I have not taken a copy of the corrupted data before restoring the backup. Is there any ...
1
vote
2answers
46 views
After moving database (backup, restore), I have to re-add user
I occasionally move a database (SQL Express 2012) from a development machine to a server, or vice versa, using database backup and restore in SQL Server Management Studio.
Whenever I do this, the ...
1
vote
2answers
71 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 = ...
5
votes
2answers
117 views
How best to maintain SQL log file sizes
I'm somewhat of a new DBA and I'm managing a SQL Server 2012 instance that has a fair amount of activity. I'm running in Full Recovery mode because we need point in time recovery.
Right now, I'm ...
3
votes
2answers
71 views
Error while taking backup using SSMS
I am accessing my sql server 2008 r2 express server using SSMS. I have about 5 logins. For a particular login I have all server roles other than sysadmin. It is a sql login(not windows authentication) ...
1
vote
2answers
37 views
Live backup without lock
In our company we have a lot of MySQL databases. Some of these are critical and we want to take a back-up of all databases. These databases can't be locked because the application can change these ...
5
votes
1answer
93 views
How do I shrink the physical Transaction Log file when it's the principal in a mirror?
We setup database mirroring over the weekend, and forgot to re-enable the job that backs up the transaction logs. When I came in this morning, the transaction log had ballooned to 58GB, and was taking ...
1
vote
0answers
16 views
Backing up file groups with restore to earlier backup SQL Server 2008
I have a task: I have created a database with a filegroup lamb that has a few tables
I need to extract a csv into a table in a file group named lamb and backup file group lamb
Then extract another ...
0
votes
3answers
42 views
Reasons for incremental backup on Progress OpenEdge
In the case that storage is not a problem: are there actually any good reasons for doing incremental backups instead of just doing full backups?
Edit
This could actually refer to any database with ...
1
vote
1answer
76 views
SQL Server to compress the backup file from procedure
Is it possible to compress a backup file to .zip (or another) in a stored procedure invoked from a maintenance plan?
My maintenance plan contains these steps:
check DB (consistency, re_index, maybe ...
-3
votes
1answer
74 views
SQL Server backup devices autentification by user without access to local computer account or AD [closed]
Please is there way to create procedure to create Backup Device by using different user account, for user account without acces to local computer and not defined in AD too, because description from ...
0
votes
1answer
32 views
Reinstall MySql but keep database tables and data
Please help!
There are server issues and MySql is no longer running on our server (Ubuntu). The service is not recognized and needs to be reinstalled. Unfortunately, the database has not been ...
7
votes
1answer
142 views
SQL Server Transaction Backups vs Logs
I've inherited a moderately-sized business-critical SQL Server 2008 database and am trying to wrap my head around backup planning. (I'm a developer, not a DBA.)
The way our system is set up right now ...
2
votes
1answer
27 views
Which MySQL directories to back up using FTP
My server has been hacked and I only have FTP access to recover my data before reinstalling the OS.
Which/where are the directories that needs to be backed up? Will MySQL be recovered back to its ...
1
vote
1answer
29 views
Best way to perform backups with filegroups and then restore those backups
Scenario:
Database consists of these file groups:
PRIMARY
xxTEST2
xxTEST3
xxTEST4
Database consists of the following files in those file groups:
xxTEST_RESTORE - Rows Data - PRIMARY - ...
0
votes
2answers
53 views
How does mysql transaction works?
I already know how to use transactions, what I want to know is how MySQL transaction handles data being processed...
For example, consider the following:
1. I have 2 databases (db1 and db2) ...
2
votes
1answer
71 views
Windows native backups makes SQL Server think that databases backup has been done
community.
I've Windows Server 2008 R2 which hosts few virtual machines.
One of machines is Windows 2008 R2 server with SQL server 2008 R2 Express installed.
Here's the thing:
I wrote a script that ...
1
vote
1answer
148 views
ORACLE restore - how to restore specific .bkp file?
I just started working with oracle and I have some issue.
My database is NONARCHIVELOG mode.
I made two backups:
they are at locations:
...
0
votes
4answers
84 views
Shortest method to upload database to server
I have a SQL Server script file which ranges size of 3gb and I am in need to upload the script file to an external server.
i generated script for my 6gb database by following these steps
...
0
votes
1answer
33 views
PostgreSQL backup error
I am trying to backup my company PostgreSQL database using pgAdmin III, so I selected our company DB from the tree, then right clicked on it and selected 'Backup', selected the destination folder ...
2
votes
3answers
106 views
Backups script completes, but doesn't back up all dbs
I'm running sql server 2005 and I've made a simple backup script that backs up all the databases on one server. The script always succeeds, but when I go to check the log or the files, I see it has ...
4
votes
1answer
79 views
Process attempted to unlock a resource it does not own
SQL Server 2005 SP4 32-Bit
I have a DBCC CHECKDB job running nightly. Last night, soon after the job started, I got the errors below. The database is NOT in suspect mode, and CHECKDB comes back clean ...
1
vote
3answers
104 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
votes
1answer
77 views
IO Frozen in error SQL error log
The log shows IO DBName is Frozen follow by thaw but yet my database schedule backup task which normally been running isn't since the network team are doing backs (not database backups, according to ...
1
vote
0answers
60 views
SQL Server 2005 Unexpected Disk Usage during Backups [closed]
On our SQL Server 2005 SP4 server we have a maintenance plan in place which performs a full backup of selected databases on a nightly basis. The databases are configured in Simple recovery mode and ...
1
vote
1answer
25 views
MySQL: parallel restores at same time from backup files?
Slightly related to this question, but for MySQL: Would it be possible/wise to execute 2 parallel restores from a single backup?
Is it possible/wise to do a parallel restore of two independent ...
1
vote
1answer
125 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 ...
0
votes
0answers
27 views
MongoDB: move documents before capping
The cappedCollection concept works well for most of my projects where cleaning old data without care makes sense.
For another projects, I need a more complex and safe concept. The requirement is ...
3
votes
5answers
234 views
How can I tell if a SQL Server backup is compressed?
We have recently upgraded from SQL Server 2005 to SQL Server 2012. Under SQL Server 2005 there is no option to create compressed backups as there is in 2012.
If you attempt BACKUP DATABASE ... WITH ...
-1
votes
1answer
44 views
Back up my ASPNETDB
I want to back up my database but I got this error:
Cannot open database "ASPNETDB" requested by the login. The login failed. Login failed for user 'My-laptop\user'.
I'm using SQL Server Express
...
0
votes
2answers
145 views
Backup Access Database Daily/Weekly
We have a Microsoft Access database split into backend/frontend. What I am looking for is to be able to automatically backup these files on a daily or weekly basis - what is the best way to go about ...
1
vote
1answer
73 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 ...
2
votes
2answers
477 views
media family on device is incorrectly formed. SQL Server cannot process this media family
I am trying to restore a .BAK in SQL server but get the following error:
Msg 3241, Level 16, State 7, Line 1 The media family on device 'c:\glyn\JA.bak' is incorrectly formed. SQL Server cannot ...
2
votes
4answers
85 views
Using Mirroring for incremental backups?
We have a machine tool application that runs on a SQL server backend. These tools run all day every day and I am looking for a way to incrementally backup the database without any machine downtime.
...
