Tagged Questions
1
vote
1answer
28 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
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 ...
1
vote
3answers
49 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. ...
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
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 ...
1
vote
1answer
149 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:
...
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
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 ...
0
votes
1answer
109 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
1answer
82 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\" & ...
1
vote
2answers
134 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 ...
1
vote
1answer
83 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
221 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
233 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 - ...
1
vote
2answers
69 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 ...
2
votes
0answers
35 views
Is it possible to have a valid backupset with null position?
In database restore process I need to rely on position column exists in backupset record to restore the latest backupset.
Restore the latest backup on the database
I noticed sometimes position is ...
1
vote
1answer
121 views
MySQL Point in Time Recovery For Just a Single Schema?
Is it possible to simply restore a single schema and bring it to a point in time (Say three hours ago) without bringing the entire database back?
I can think of a lengthy method of backing up each ...
1
vote
3answers
202 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 ...
3
votes
1answer
55 views
SP for Restoring Database and performing other tasks on it
I am creating a stored procedure for our QA dept that will do the following:
Accept specific inputs to generate a consistent name, restore a database (giving it the generated name,) set the db up for ...
0
votes
1answer
129 views
mysql duplicate entry error 1062 when restoring backup
Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this.
Requirement: To create an exact replica 'db4' of an existing DB 'db3'.
Procedure ...
6
votes
1answer
282 views
Restore a Database to a New database (T-SQL)
I have a database backup from a database, say SourceData which needs to be restored on another database, same schema, but different name (SourceData_1) using T-SQL. I don't know why I gets the ...
3
votes
1answer
448 views
Cannot restore Amazon RDS SQL Server database to given point-in-time using SQL Server Management Studio
I'm trying to restore one of my Amazon DRS SQL Server databases. Using SQL Server Management Studio, I can correct to my DRS instance using the master account I created when creating the database ...
5
votes
1answer
188 views
SQL Recover from .bak file with NOINIT
This will, hopefully, be a nice and quick question for someone out there. It continues from my previous question.
I have a .BAK file that I'm trying to restore. The .BAK was created with the NOINIT ...
1
vote
1answer
255 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 = ...
2
votes
1answer
139 views
Restore database from individual datafile backups
I had a script that backs up all the individual datafiles like:
RMAN> BACKUP AS COMPRESSED BACKUPSET DATAFILE 'datafile<1>.dbf'
So i have backupsets of all the datafiles. I'm confused as ...
0
votes
2answers
232 views
Row level restore with Oracle Recovery Manager (RMAN)
We're approaching the end of 2012 and I still find myself relying on database exports to maintain the ability to do row level restore operations. While this is a proven method, it sure would be nice ...
-1
votes
1answer
312 views
Oracle XE: Transfer Database from Linux to Windows
our professor gave us a linux VM with a Oracle XE 11g Database.
I want to transfer this Database to my Windows installation because I dont't want to boot up the VM for every exercise.
Everything ...
1
vote
2answers
665 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 ...
4
votes
2answers
291 views
Restore all applicable files in a backup device in T-SQL
I'm using SQL Server (2008 R2 in this case) and I am backing up my databases into backup devices (one per database). Every Sunday the device is overwritten with a new full backup, every night a ...
2
votes
3answers
629 views
Copy PostgreSQL data from one PC to another
I am migrating my server application from the existing system to another system. Unfortunately, the existing system is also the database server. It has data stored. Is it possible to copy this data to ...
7
votes
1answer
121 views
SQL Server considerations when backing up / restoring a database that uses replication
In the event that I need to restore a database involved in replication, what considerations to I need to keep in mind?
Do I need to keep backups of both the publisher and the subscriber?
Can I ...
0
votes
1answer
595 views
Oracle big datafile restore fails using Netbackup (ORA-19511, ORA-27190)
I am restoring datafiles about 1000GB in size. I am using Netbackup as a backup server.
After 2 hours reading Netbackup fails with the following error:
7/25/2012 3:27:50 PM - Error bpbrm(pid=1176) ...
1
vote
1answer
141 views
Failed to restore mysql database with zmanda
I want to setup a slave from my backup version of mysql using zmanda (it's a full backup).
I've followed this guide.
Result of mysql-zrm-reporter
backup_set backup_date ...
1
vote
1answer
147 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 ...
0
votes
0answers
131 views
change database name controlfiles after restore?
I have restored database with the name DB to another database called DB01
it is in STARTED status (not mounted) and it seems I can not change the name if it is not mounts, and I can not mount it ...
1
vote
1answer
349 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
...
3
votes
1answer
768 views
Why is my postmaster process (sometimes) becoming unmanageable after a WAL base restore?
TL;DR: Un-stoppable, unusable postmaster is being spawned when Postgres is started right after restoring its data directory from a WAL base backup. Why?
Context:
We run postgresql 8.4, on CentOS 6, ...
4
votes
2answers
3k views
Can I restore a SQL Server .bak files without SQL Server?
I have some large .bak files from a SQL Server 2005 dump.
Can I restore these without using SQL Server, either to PostgreSQL, MySQL, or to flat text files?
An open source solution would be most ...
2
votes
2answers
274 views
Would it be possible/wise to execute 2 parallel restores from a single backup?
Every night I create a backup (to disk) of a particular database. Subsequently that backup has to be restored to 2 different servers. These restores now happen sequentially and take about half an hour ...
-1
votes
2answers
2k views
Extract mdf & ldf files from backup file?
Is there a way to extract SQL Server files (.mdf & .ldf) from a backup file (.bak) to a physical location, without restore database?
I need a restore query or script to restore files from bak ...
3
votes
1answer
78 views
Is it imperative that I backup my index files?
I have a few different instances (SQL 2000, 2005) with indexes placed in a separate filegroup. Do i need to ensure that this group is backed up, or will it be rebuilt by a restore of of the database?
3
votes
1answer
122 views
Transactional versus Merge Replication (Restore backup after downtime)
I have the following transactional replication setup:
Windows Server 2008 with SQL Server 2008 Enterprise
Server A: Master, has a database with a table, publisher
Server B: Slave, subscriber ...
1
vote
1answer
2k views
Problem with View When Restoring a MySQL Backup
I have a database (InnoDB) with some tables, views and routines...
Periodically I do a backup using the command line:
mysqldump -u user -ppassword --routines db_name > backup.sql
But I have a ...
2
votes
1answer
119 views
SQL Server asks for 100GB for a dump with 1GB
Is it acceptable that SQL Server asks for 100GB free disk space to restore a 1GB dump file?
If no, what should be parameterized?
0
votes
2answers
2k views
Opening a .backup file for PostgreSQL
I'm going to warn you that whoever explains this needs to talk to me like I'm five years old, because this is something way, way beyond my level of expertise.
In short, I have what I think is a ...
3
votes
1answer
716 views
PostgreSQL Scheduled Database Backup
For scheduling a daily back up on a postgres database we execute the following command:
0 2 * * * /usr/local/pgsql/bin/pg_dump -Fp -b -U database_name \
> ...
2
votes
2answers
179 views
Can I move a system database from one version of SQL server to another?
We are moving our databases from one computer running SQL Server 2005 to a different machine running SQL Server 2008.
I am following the steps found here, in an attempt to copy over the master ...
5
votes
2answers
775 views
SQL Server backup, attach to BAK file?
I have a SQL Server database with a full text index. When I created the app that uses it, I made a backup of the database and I ship the .BAK file with the app. As part of the app install it does a ...
2
votes
1answer
231 views
Postgresql revert back database value
I have postgresql database.
My table name is tblvoippolicy. Now, problem is by mistake i have deleted some records from table.
When I get the data file using following commands.
select * from ...
