New answers tagged

1

The problem this caused was that the log file (which also gets backed up) is now unnecessarily large because it includes the FILESTREAM data. I'm not sure if you mean the log file itself is too large or that the log file backups become too large. If it's the former then how often were you backing the log up? Depending on the application design you may ...


0

The solution is quite simple. The issue is that the secondary node is set to 'Readable'. This locks the log file and any operation to shrink it will always fail with error 'The log for database [databasename] cannot be shrunk until all secondaries have moved past the point where the log was added. Change the configs for the AG and make the secondary ...


0

Assume the case where you make full backups once a week (on Sunday) and transaction log backups every 15 minutes. Then the database failure occurred on Saturday night and now you need to restore your database. In such case, you need to to restore the last full backup that was made on Sunday plus all transaction log backups that you were made from Sunday to ...


0

It depends on you restore time Differential backup helps you reduce the restore time Imagine that each of your logs takes half an hour to restore and imagine that your database fails on Saturday So you have to Restore the full backup of last Sunday + many log backups which will take so much time but If you have differential backup every 6 hours you will ...


3

My problem is what is the use of differential backup every 6 hours if we are taking a transaction log backup every 15 minutes? Differential backup is used to decrease the Recovery time object(RTO), it gives you facility of restoring backups quickly. Differential backup includes all the changes made since last full backup, or full backup which started ...


2

The use of the differential Backup is simple. Instead of restoring a huge amount of log backups in a row, you restore a full, a diff and a small amount of transaction log backups instead. Yes you are correct, you don't need the differential Backup, logically. But your restore will be faster using full + diff + log backup compared to a full restore + ...


2

I've always had such an aversion to cursors, that I wrote this as I can better understand it. It's totally based off of AA.SC's answer (thank you by the way), just put in a way that I think. If this jives with what others think, then great. Note, I didn't put it back into Full recovery mode afterward though. SELECT '--', d.name dbName, d.recovery_model, ...


2

I have never used SharePoint or worked with its databases specifically, but both links in your question indicate that you should be able to see, and work with, SharePoint databases in SQL Server Management Studio. The fact that you cannot see them in your particular case most likely means that they are hosted by a different server instance – not the ...


3

on this question: How to identify which query is filling up the tempdb transaction log? you will be able to see a lot more, in different ways and with more technical information as why this is happen and what to do regarding it. below is a script that I have to check what is filling up the tempDB. it may be a good starting point for your quest. use ...


1

The final reason for this effect was that the Backupexec process responsible to take regular log backups was still present and running (so IT monitoring did not alert anything), bunt it was kind of internally crashed, so it did not do it's job properly. In order to address this kind of event I decided to add the log file events and it's metadata details to ...


1

Full recovery model and no log backups? AlwaysOn not pushing data? (so unable to re-use the log filespace)


0

If you perform a full RESTORE WITH RECOVERY, that means you want to only restore the full backup and immediately bring the database online. When you perform a full RESTORE and want to also restore differential or transaction log backups as well, then you want to RESTORE WITH NORECOVERY so that the database does not come online and additional restores are ...



Top 50 recent answers are included