0
votes
4answers
81 views

How can I restore a database such that I can use it on a server where I don't have the security admin role

On a SQL 2008 instance, I have a login with the dbcreator and public roles. When I restore a database onto this server, I am then unable to use that database because all the user -> login mappings in ...
0
votes
1answer
458 views

SQL Server 2008 Error when restoring DB backup: “specified cast is not available”

I was using SSMS to restore a database backup onto another database in a SQL Server 2008 instance, when I received the error message: "specified cast is not available". The backup was made on a SQL ...
4
votes
2answers
13k views

Export and import a PostgreSQL database with a different name?

Is there a way to export a PostgreSQL database and later import it with another name? I'm using PostgreSQL with Rails and I often export the data from production, where the database is called ...
1
vote
2answers
616 views

Restore Bacula Files

Q1: Can I restore bacula files to another location? Because whenever I restore my bacula files, it goes directly to the client on which the files was backed up. Q2: Can I restore bacula files if ever ...
0
votes
2answers
471 views

SQL Server: Restore database, data copy-redo-undo, clarification?

I have tried to understad how database restore works in SQL Server. I have read from BOL about different phases within the restore operation but did not understand much. Can you please clarify what ...
0
votes
1answer
204 views

Rebuilding a MySQL database from 160 retreived files with no name

I had a server crash and it took with it the hard drive. I put the hard drive in a USB enclosure, but the main partition would not mount because the partition was corrupted. I was able to see the USB ...
1
vote
1answer
82 views

What does SQL Server do if you select more than 1 full backup when doing a restore?

I have a backup file that contains 2 backup sets. Both backup sets are full backups. When I open SQL Server Management Studio and choose "Restore..." and pick the file as my device, it lets me pick ...
3
votes
2answers
2k views

Command line scripts to restore the 4 system databases of MS SQL Server 2008

can someone give me some advice on how to restore the 4 system databases (master, msdb, model, tempdb) of a sql server 2008 please? I've already done some testing myself (on restoring the master ...
1
vote
1answer
1k views

PostgreSQL Backup/Restore

What's the best way to backup a postgresql database? I've tried using the documentation at www.postgresql.org, but I always get integrity errors when restoring. Right now I'm using this for backup: ...
1
vote
1answer
268 views

Problem with restoring a Blackberry configuration database on Microsoft SQL Server

I am attempting to restore a Blackberry configuration database on Microsoft SQL Server 2005. The command goes like this: restore database besmgmt-test from disk = "C:\besmgmt-test.bak"; with move ...
0
votes
2answers
89 views

Am I backing up my database correctly? And then load it as INNODB?

mysqldump -hlocalhost -uUSERNAME -pPASSWORD THEDATABASE | gzip > /home/db_backup/abc.sql.gz tar -xzvf ./abc.sql.gz mysql THEDATABASE -uroot -pPASSWORD < abc.sql The important note is that ...
3
votes
6answers
827 views

How do I restore to a SQL backup I made two days ago?

Database disasters only happen to other people, right? RIGHT?!? I'm sure this has never happened to anyone since the beginning of computer history, but, believe it or not, I'm having a problem with a ...
1
vote
3answers
2k views

How to transfer a postgres database to a different server

I'm planning to transfer a ~100GB Postgres database to a new server. Is it save to just copy the data directories to the new server and start up the database there, or do I need to do a dump on the ...
0
votes
1answer
148 views

Good off-site backup solution for database and files

I was searching for a tool that would make remote backups/restores easier for both database and files, but I couldn't find any, so I started thinking about creating my own online service that deals ...
14
votes
1answer
10k views

How can I do a dump of only the table structure in PostgreSQL?

In a similar vein to this question, how would I do a schema-only dump in PostgreSQL?