Tag Info

Hot answers tagged

4

You need to restore last FULL backup, the Differential, the 10:15 transaction backup and the 10:30 one with the STOPAT = '2015-05-22 22:24:00' clause.


3

The jobs are themselves stored in MSDB: I believe taking regular backups of system-- MSDB database should do good: Else you can perform some manual stesps as listed below: Start SQL Server Management Studio. Expand the SQL Server Agent folder, and then expand the list of Jobs. Right-click the job you want to create a backup script for, and then ...


3

You most probably re-index your database between the log backups. This means your log backup contains a lot of transactions from these maintenance operations. Please check your maintenance plans. The size of transaction log can be huge compared to your actual database, imagine this situation. You delete 100k rows and add 100k rows between your backups. Your ...


3

First things first, before you restore anything - back up your log with no_truncate. If your database is offline, then take a copy of your LDF file first, then bring your database online, ignoring any errors, and then do your log backup. This log backup is then the last one in your recovery process, which involves a full database backup which doesn't have ...


2

You start by making a tail of the log backup of the damaged database, backup log database to disk = 'disk' with no_truncate. You then restore the database from your last full backup backup, with no recovery and then restore your all your log backups ending with the one you made with no_truncate see this kb article: ...


2

If you want to be sure that you're backups are going to tape, you need to periodically recall the tapes and restore the backups. We recall tapes once every three months to do this, it seems like a lot of effort but it is not overkill if you value having offsite backups.


2

If the "SQL Server VSS Writer" service is running IO on the database files will be "frozen" while a snapshot is made of the databases and the database state (full database backup) will be included with the VM backup. This will not lock down the SQL server but will in some cases make it slower. If the service is not running the database files will not be ...


2

On way would be to restore only the relevant table to a new empty dummy database. Then find rows with standard SQL tools. Not sure if you are restricted by Heroku in any way. On the shell, as postgres user (or any user with sufficient privileges) first create an empty staging DB: createdb -T template0 dummy If the DB isn't too big and you have plenty of ...


1

The last LSN of the FULL BACKUP should match the Last LSN of the log backup. This will be your first log backup and then after that the consecutive log backups will be having A.LAST_LSN = B.FIRST_LSN --> where B = log backup taken immediately after A. From BOL : Now look at the error you are getting : The log in this backup set begins at LSN ...


1

You are trying to apply a Log file that finish with LSN 421814812000000025600001 into a DB restored with LSN 421787067000000013800001 , so, the LSN of the Full Backup (restored) is older than the log file that is trying to apply. So, the log file would not possible to apply , being a change in sequence. So possible cause here being that you are not ...


1

First of all grab Ola Hallengren's scripts to do the backups (http://ola.hallengren.com) and drop the maintainance plans. Ola's scripts have much better retention settings and will allow you to set a mark in hours how long to store the backups and know how to take the backups of the secondaries. And for your questions: Set up a small script in SQL Server ...


1

performance_schema: Not necessary. It may contain performance metrics that are only good for the time you were using the instrumentation. It would serve no purpose to load collected metrics from the past into another MySQL instance or into the same MySQL instance at a much later time. mysql : BE VERY CAREFUL HERE !!! If you backup mysql, you can only reload ...



Only top voted, non community-wiki answers of a minimum length are eligible