SQLSteve (7/15/2014)

---

I have just set a SQL 2012 availability group up, testing it is working and all seems fine.

I am not adding a listener to the set up and after...

your clustername account (domain/ CLUSTERNAME$) should have the full permissions to create objects in AD or you can manually go to AD and find your listner name and under security...

Yep, it happens, since it got corrupted internally on system indexes , it hard to repair and all user tables do use the system catalog to locate the data. if...

There is lot to consider in re-org vs re-index. In simple words, yes, less than 30 % fragmented good to do re-org else re-index.

For example.you have 90%...

Recover from the full backups and log backups to the point is the best bet here.

If you don't have the backups then pretty much , you have to pull...

I see this is a old post but I got the similar error today and I got it fixed through just taking the database offline and bring online. I got...

Nope, its not when you restore as a different user database, I tested it before.

Master database has a set of restrictions when moving from one version to another version, the standard rule is Master can be restored to same version and also more important...

If you are trying to achieve HA then make sure your 2 VMs are from different hosts. then configuring will be almost same as you configure the physical clustering.

When you create a subscription it creates a SQL agent job to automate, check you agent is not down.

andrew gothard (3/27/2014)

---

@SQLFRNDZ (3/27/2014)

---

Hi All,

I have a odd scenario, For example.

Say database is Full Recovery Model, No Log backups Configured , Then Obviously TLog grows till disk...

Adi Cohn-120898 (3/27/2014)

---

Well, you are wrong. Checkpoint will occur. In fact one of the factors of that cause checkpoint is database backup. Of course there are other...

That is excellent tool. Thank you !

Edit --

Some vendors provide the custom maintenance for thier applications , if not the In--house DBA should implement the maintenance and check with Vendor to see if there is any...

it is easy to find with powershell, follow this link