Time line: 1_ Made backup of database 2_ Deleted a row from table that deleted +100 others records in other tables since they where with the constrait ON DELETE CASCADE. 3_ Made backup of database 4_ Made a lot valid of updates/deletes/inserts. 5_ Need to recover the data lost in 2 I've seen the rollforward db2 command, but it's n...
Let's say I have a database like this: Users ----- ID int PK Identity Name vchar(max) Sales ----- UserID int FK Description vchar(max) And some data: Users 1, "Daniel" 2, "Barnie" 3, "Frank" Sales 2, "New computer" 2, "Rubber duck" 3, "Cabbage" There are also several other tables that link to this primary key. Now there is a req...
Has anyone study the performance impact (positive or negative) of using Data Protection Manager as a backup and recovery tool for SQL Server? ...
I would like to create a backup script (.sh that I can cron) that backs up the following databases: someotherdatabase database1 database2 database3 database4 database5 database6 ... database9999 I know "someotherdatabase" will always have that name so that can be backed up easily. The other databases have an incremental number but I d...
I am using the Database Backup script by David Walsh(http://davidwalsh.name/backup-mysql-database-php) to backup my MYSQL database as a .sql file to my server. I created a user named backup and gave it all privileges(just to make sure). Then I put the code into a php file and setup a cron job to run the php file. This is the code: /* ...
Hi, one of my colleagues suggested that I should make different databases (MySQL) for each client, so that if one account is compromised, we only need to restore a backup of a single database. I'm concerned about a fast access to the data: which is faster? selecting a database among thousands of them, or finding an entry among thousands ...
Is there any way to find whether the database is in backup mode or not. Is any sys tables can provided this informtion. ...
I have a decent sized PostgreSQL database (approx 6GB & growing). A full backup/export of the database is done every few hours via cron & pg_dump. Specifically, can I export only the changes to the database since the last export? Or perhaps run a utility that compares the two exports and appends the differences to the original, etc? I...
Through SINGLE T-sql query can we find : 1. Database Backup mode - [full,simple,bulk] 2. IS database is scheduled for backup [yes, no] 3. If backup is enabled the size of the DB backup and Daily transaction log backup size ? any help ...
I have an SQL Server 2005 instance whose full backup (.BAK) failed due to low disk space. However half hourly transaction log backups continue (.TRN). Assuming I have an older full backup, could these continuing transaction logs be used to restore the database? i.e. do the transaction log backups only run from the last successful back...
I would like to be able to run an on demand backup of a .Net MVC app's SQL Express 2008 database to eg a flash stick plugged into the machine running the app. I tried QuickstemDataContext db = new QuickstemDataContext(); string quickstem_path = Path.Combine(save_path, "quickstem.backup"); db.ExecuteCommand(string.Format("BACKUP DATA...
Hello. Our goal is to restore a test environment from our live environment, so basically we would like to simply backup our current live databases, and just restore them in our test server. However... we do not have enough room to move the backups, one of our databases is 50 GB, and we only have around 20 GB free(the backup is 40 GB u...
I want to switch from MySQL to MongoDB but great data losses (more than 1 hour) are not acceptable for me. I need to have 3 backup plans: Hourly backup plan. Data is flushed to disk every X minutes and if something wrong with the server I shall be sure that after reboot it will have all data at least for an hour ago. Can I configure i...
I made a backup of my_database like this: mysqldump --add-drop-database --databases --user=my_username --password=my_password my_database > backup.sql Then I deleted the database completely, and tried to restore it like this: mysql --user=my_username --password=my_password my_database < backup.sql I got the following err...
Hi folks, I'm trying to backup my database with: pg_dump my_database > backup.sql unfortunately there are no privileges set for many objects in the database, therefore the command does not work! Furthermore this does not grant privileges as expected: GRANT ALL ON DATABASE my_database TO root Any ideas? ...
I have a 250 MB backup SQL file but the limit on the new hosting is only 100 MB ... Is there a program that let's you split an SQL file into multiple SQL files? ...
So we have a production database that is 32GB on a machine with 16GB of RAM. Thanks to caching this is usually not a problem at all. But whenever I start a pg_dump of the database, queries from the app servers start queueing up, and after a few minutes the queue runs away and our app grinds to a halt. I'll be the first to acknowledge th...
I used the SQL Server Maintenance wizard (along with a book) to generate both Full and Differentail backups. The Full backup runs on Monday morning and the Differentials run Tuesday through Saturday. The Full backup runs fine and generates the following email report... Microsoft(R) Server Maintenance Utility (Unicode) Version 10.0.2531 ...
I am using mysqldump to create a canonical installation script for a MySQL database. I would like to dump the data for able half of the tables in the database, but exclude the data from the other tables. I am aware of the following two commands: --no-data --ignore-table But the first applies to all tables, and I believe the second exc...
I'm am trying to use mysqldump to export a database which needs to be imported using a different database name. Looking at the SQL generated by mysqldump, it appears that triggers are the only object names which are fully-qualified with the source database name thus foiling my needs. Is there anyway to direct mysqldump to not fully-quali...