Viewing 15 posts - 106 through 120 (of 1,318 total)
Good luck! Honestly it can be like playing Whack-A-Mole if you have a busy database :D.
March 15, 2019 at 6:55 am
can't figure out why I'm getting this. I thought the "Full" synchronization option was supposed to handle most of this for me.
No, if another transaction log backup is taken...
March 15, 2019 at 2:43 am
March 12, 2019 at 8:03 am
You say there are no maintenance jobs, but are there any SQL agent jobs? The backups may be being initiated on another server/instance, too.
March 12, 2019 at 3:19 am
Have you tried doing a manual checkpoint on that database?
March 11, 2019 at 8:22 am
Can you check the msdb.dbo.backupset history to see if it can shed more light on which account initiated the backup? There's a user_name column.
Also, what format is the...
March 11, 2019 at 8:19 am
I am restoring databases from SQL 2012 backup(full, differential and logs) to SQL 2016.
If I...
March 11, 2019 at 5:18 am
The only way to do it is to remove it and create it again. Alternatively you could create a DNS alias with the name you want and point it at...
March 6, 2019 at 7:55 am
What Leo Miller is referring to is correct. What you really need when you can get some downtime is fail over to the other side, and drop and recreate the...
March 5, 2019 at 1:36 am
Sorry for your loss, Jeff. What a tough time many people are having right now.
March 4, 2019 at 5:03 am
It's because differential backups write to the database (to update the differential bitmap), and that's not possible in a secondary replica because it is read-only.
February 20, 2019 at 2:48 am
Lynn, I'm so sorry for your loss.
February 18, 2019 at 1:51 am
Can you give us some more detail please. Where did you restart the service?
February 18, 2019 at 1:47 am
It's a known issue/expected behaviour. If you don't need synchronous commit mode*, you can mitigate some of the issues by switching to asynchronous mode.
suspect this is...
February 15, 2019 at 1:49 am
I think adding your jurisdiction/location/retention requirements and any other regulatory considerations might help others to know what to recommend to you. Reading between the lines I think you are probably...
February 13, 2019 at 1:30 am
Viewing 15 posts - 106 through 120 (of 1,318 total)