Have you checked the disk integrity where the log backups are moved to on the secondary server?

You're welcome 😎

Ravid_ds (1/31/2014)

---

Hi Experts,

This could be a laymans query, please help.

We are planning to move a StandBy/Readonly mode Database to a new server. This DB is not configured for log shipping....

Brad Scheepers (2/11/2014)

---

USE master

ALTER DATABASE myDatabase SET offline

ALTER DATABASE myDatabase MODIFY FILE (name=myDB_filename, FILENAME='X:\New_Path\myDatabase.mdf')

ALTER DATABASE myDatabase MODIFY FILE (name=myDB_logname, FILENAME='X:\New_Path\myDatabase_log.ldf')

** Physically move the files at this point to their new...

The differential base lsn results indicate that since you restored the full backup from prod another backup had been taken against prod, @ 1pm on the 13/02 to be exact....

No, listeners are per availablility group. Don't confuse the AO listener with Oracle listeners

TerrenceTheCat (2/13/2014)

---

Hi Perry,

Thank you so much for your help. Below is the output from the query you asked me to execute

(No column name)name ...

muthyala_51 (2/12/2014)

---

Thanks a lot Perry !! I am also having trouble to understand what exactly the alwayson availability group listener is ? What this is used for? Does it acts...

I use the Litespeed suite including OLR. The Litespeed OLR is helpful, but as table object sizes grow, performing an OLR restore can take just as long as restoring the...

peter.cox (2/12/2014)

---

I have measured for Allocation, and there are (what I'd class as) a lot of pagelatch_ups.

There are issues elsewhere; it's a single job, with 65 different steps. As I...

TerrenceTheCat (2/12/2014)

---

Hi Everyone,

I am testing a DR scenario at work but having problems. Our backup strategy consists of

1 nightly full backup

Differential backups every few hours

Transaction log backups every 10 minutes

I...

Oracle_91 (2/11/2014)

---

1) Who is responsible for moving those transaction log records from Principal database to mirror database? I mean, who or which thread is going to read those log records...

CSVs are not something i use, they do seem more to be tied to HyperV as a way of sharing VHDs. A little like VMWare VMotion. Why do you feel...

newbie_DBA (2/11/2014)

---

trying to find out if this is the best way to move log files in databases that are in an availability group.

remove the DB from the AG

Run...

peter.cox (2/12/2014)

---

Morning all

Got a puzzler here. Newish firm, with a massive overnight process

Tempdb is a single datafile at the moment, on it's own 300GB disk. There are 12 cores, doubled...