Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.
-3
votes
1answer
93 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
46 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
150 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
29 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
32 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
66 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
96 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
333 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
91 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
...
2
votes
3answers
126 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
100 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
122 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
90 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
66 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
29 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
138 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
39 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
297 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
51 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
240 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
77 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
1k 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
103 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.
...
0
votes
2answers
298 views
SQL Server 2008 R2 Restore COPY_ONLY full backup with transaction logs
After doing some research I cannot seem to find an answer to this question.
Background
I am attempting to setup a backup plan that fits the following three requirements:
Reliability of backups, ...
0
votes
1answer
161 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 ...
0
votes
0answers
60 views
Tape rotation strategies
I am trying to find a tape rotation strategy that would be optimal under the following conditions:
Backup Media Rotation strategy should support the following:
Media Archives required ...
1
vote
1answer
149 views
MySQL backup InnoDB
I have a VoIP server running 24x7. At low peak hour at lease 150+ users are connected. My server has MySQL running with InnoDB engine on Windows 2008 platform. I like to take at least 2 times full ...
4
votes
2answers
123 views
List DB2 backups
Is there a way to list the DB2 backups? All I can find is db2 list history backup all for <dbname> but I think you need to check through all of those to see if they've since been deleted. This ...
3
votes
1answer
111 views
SQL availability groups log maintenance
I have a AG with 2 nodes in a site in sync mode and 1 offsite in async mode. I'm having trouble understanding how the logspace is maintained in this scenario. For instance, I'm taking log backups ...
4
votes
3answers
157 views
Backup strategies for zero data loss
I am working on one project and it has around 100K records. We can afford a downtime of 1 day but we need the data to be always available to us in latest state.
I've gone through two options:
1) ...
2
votes
1answer
109 views
Backing up a 400-500 GB database on MySQL/Amazon RDS?
We have an Amazon RDS small instance for a MySQL datawarehousing database.
Database size will be around 400-500 GB very shortly.
What is the best way to backup our database?
Can it be done ...
0
votes
1answer
101 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\" & ...
0
votes
1answer
101 views
Restoring a differential backup in SQL server 2005 [duplicate]
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\" & ...
0
votes
0answers
32 views
Performing a Transaction Log Backup on a Live Database [duplicate]
I have a server 2012 database that has a transaction log that is growing at a rapid rate. i have a job that runs once a day after production hours which backs up the log file and shrinks it.
The ...
1
vote
0answers
74 views
How to backup a running SQL Server CE database with full data?
I need to move my running windows-based app (built in C#) to another machine, but I also need to transfer the whole data, how can I take a backup from the .sdf file and use it with the new installed ...
1
vote
2answers
150 views
What's the best way to backup DB files via network on Linux and Solaris machines?
I wonder what the best way to backup files via the network.
I have Solaris machines with Oracle 10i on a Veritas cluster. Machines are connected to EMC storage.
The /data/oracle directory is mounted ...
2
votes
1answer
75 views
How to tell what's failing at making backups?
I have an instance of SQL server that is regularly getting errors like this:
02/25/2013 23:22:38,spid138,Unknown,BackupVirtualDeviceFile::SendFileInfoBegin:
failure on backup device ...
1
vote
1answer
149 views
Is storing archive logs on local disk and backups on vendor storage possible?
I am using DB2 9.7.
My LOGARCHMETH1 is set to VENDOR library. Example:
LOGARCHMETH1=VENDOR:/usr/openv/netbackup/bin/nbdb2.sl64
Is it possible to call the following backup command:
db2 backup ...
1
vote
1answer
101 views
DB2 online restore - “SQL1035N The database is currently in use.”
I am trying to do ONLINE RESTORE ROLLFORWARDING TO END OF LOGS AND COMPLETE. When I run this command I am getting error SQL1035N The database is currently in use. It does not allow any connections to ...
1
vote
1answer
57 views
Online backups with VENDOR library: what should be set for ACTIVE LOG PATH?
My customer is using Veritas NetBackup so we use its library file in the LOGARCHMETH1 parameter for the VENDOR option. That is for archive logging path.
What path should be set for ACTIVE LOG PATH ...
3
votes
0answers
96 views
What are the best practices for backing up a secured SQL Server 2012?
I want to state right off the bat that I'm not looking for information on how to backup a SQL Server. I've got that taken care of.
I'm looking for some form of documentation that will tell me the ...
1
vote
1answer
315 views
DB2 Online Restore but Without Roll Forward?
I read a lot of documentations for db2 restore but I could not find how to perform online restore from the last database backup but without roll forwarding of logs?
I will appreciate command ...
1
vote
2answers
304 views
SQL Server - backup / restore schema only (not a duplicate if that's what you're thinking!)
We have a DB on over 100 servers of which we want to backup / restore the structure of just 1 at a time to a specific UAT database. They're all called the same thing but vary in terms of schema - ...
0
votes
0answers
64 views
How to do point in time recovery of binary log files into .sql file
I have written a shell script to do an incremental backup of MySQL database.
For point in time recovery I'm using the binary logs generated in /var/lib/mysql directory.
For point-in-time recovery, Im ...
1
vote
3answers
165 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
2answers
73 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 ...
3
votes
1answer
228 views
SQl Server 2008 R2 - sa can login but not access database
Up until this morning I had no problems accessing our database.
This morning, something has changed and I can no longer access our database (called EMS_Main) using the sa login. I can log into the ...
2
votes
3answers
157 views
How to retrieve master log position and master log file in shell script
I'm writing a shell script for point in time recovery for MySQL database.For the below statement I need to specify the start position and end position of a log file.
mysqlbinlog ...
4
votes
2answers
263 views
Restore SQL Server database from .sql files
So we had an encrypted database that puked and killed our whole SQL Server setup. Sucks about our data, but we were smart enough to have our data structures / stored procedures / functions in Git
The ...
0
votes
0answers
114 views
Mysql Incremental Backup and point in time recovery
I'm writing a shell script using the concept of binary logs for point in time recovery.
Now, the scenario is such that a full-backup will happen every alternate day and Incremental backup should be ...
