Tag Info

New answers tagged

0

If the tables were dropped, ApexSQL Recover can recover them even from databases in the simple recovery model. ApexSQL Recover can recover both table structure and table records On the other hand, ApexSQL Log cannot recover records lost when a table was dropped, it can only recover the table structure In case the records that were lost using DELETE (not ...


0

It was an issues on the hard drive. It never showed any errors in event viewer or the controller. When we rebooted the server, the errors showed up and we replaced the drives.


0

Thanks you! Would the Veeam backup cause issues with my Database backup chain? In the SQL Server logs I can see list of records detailing databases backed up AFAIK there is no Third party tool which can take transaction log backup and truncate the logs like inbuild TSQL code. If you are looking into point in time recovery please dont rely on third party ...


2

Veeam will give you full backups of your SQL Server VM which are not that useful when all you want to do is restore a database to see what a particular value was on a certain date. You don't want to de restoring an entire server to get at a database. The replication gives a level of High Availability but it wouldn't save you from someone running a stupid ...


1

Yes, this scenario is possible in NOCATALOG mode. I did exactly this on 9.2 last Saturday so I can vouch for it :) Your attempt was almost successful. The only thing you did wrong is you restored the control file that was too new, it was above Reset SCN 246779908. If you move away C:\brubru\auto\c-2176828955-20130518-00 it would probably find a bit older ...


0

Setup a slave. Once everything is sync'd up and good. Stop the slave (sql thread). mysqldump slave data to orig.sql run your queries to modify the data mysqldump again to dev.sql Restore the data using orig.sql start slave to resume collection from the master. This will take some time with a large db of course but it seems pretty straight forward to ...


1

Generally speaking a differential works very similarly to a full backup, except that only the changed extents in the DCM are backed up. Differential backups still contain a portion of the log needed to be transactionally consistent. This will differ for every environment and is not "known" at the time of backup. You can use the RESTORE HEADERONLY of the ...


0

It would make more sense in my opinion to do a backup by table instead of by database. Here is a script I use to make backups of databases that contain MyISAM and InnoDB tables. #!/bin/bash USER="some_user_account" STAMP=$(date +"%d-%m-%y-%H:%M:%S") PASSWD="some_password" HOST="some_host" db="some_database" FILE="/some_directory/some_file-$STAMP.sql.gz" ...



Top 50 recent answers are included