Tag Info

New answers tagged

0

First thing if transaction log is not damaged you should go for tail log backup. That would cause minimal data loss. Then restore would be Weekly full backup with no recovery 10:05PM Differential backup with no recovery All log backups after this differential backup with no recovery and finally tail log backup with stopat command with recovery Please ...


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.


0

I have create following Procedure which goes thru all SP and Views in particular DB (can be extend to Functions, ...) and store each code script one by one into TXT files. Tested ON MS SQL 2008 R2 and 2014 First part Inserting all scripts of SP and Views into Temp table. Then later using BCP utility. If you wish you can can use for export SSIS package and ...


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 ...


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 ...


0

[soapbox] I would tell them "for security reasons" you should provide Windows Authentication access to that storage. Ask them if they really want authentication information in plain text saved to access a box that stores all the data for the organization and would give a user full access to their data (unless you are encrypting your backups)? ...


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 ...


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 ...


0

Not sure what you expect from partial backups, but they are only useful for read-only filegroups: partial backups are designed for use under the simple recovery model to improve flexibility for backing up very large databases that contain one or more read-only filegroups. Differential backups are a different story, but they are not used as you use ...


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 ...


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.


0

If you can setup a linked server to the source database server you can simply do a restore from the last backup device containing a full database backup by finding the last backup file like this: Declare @Database sysname = 'a' Declare @BackupFile NVARCHAR(1024) select @BackupFile = bf.physical_device_name from (select MAX(ISNULL(bs.backup_finish_date, 0)) ...


0

I was getting this error when attempting to backup a database with multiple file groups without specifically specifying each file group in the backup statement on SQL Server 2008. As soon as I added a FILEGROUP = N'FileGroupName' for each file group it worked.


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 ...



Top 50 recent answers are included