No they don't, as Gail said they're based on the LSN from the last log backup.

akhamoshioke...

DBA_Learner (5/4/2014)

---

HA?

DBA_Learner (5/4/2014)

---

Based on previous statistics when we did maintenance it took approximately 14 hours to complete the maintenance tasks. I am not sure if business teams can...

DBA_Learner (5/3/2014)

---

We are planning to move 3-4TB of databases to new environment. Can someone explain some best practices. What should we supposed to take pre and post considerations. Looking for...

Is the oracle database on unix or windows?

Both sql server and oracle have their own TDE feature but that wont encrypt the comms point to point. Best way would be...

Permanent snapshots can indeed be problematic.

+1, Theyre always misused, snapshot disks, back them up then remove snapshot.

This is exactly how...

support-555807 (4/30/2014)

---

We have a database that is over 612Gb and growing. Our backup is being done on tape using Backup Exec 2012. This process starts at 10PM and runs until...

SQLSteve (4/30/2014)

---

Sean Lange (4/29/2014)

---

SQLSteve (4/29/2014)

---

What is everyones view on accessing SQL data which is stored on SQL instances in the DMZ via management tools on your local desktop?

Would you put...

Clarify what you mean by one db, do you mean 1 instance?

The 2 terms have...

this is the behaviour I have observed across SQL server 2012 and 2014. The listener is a VNN and VIP into the instance itself and not the availability group.

Before you destroy the cluster and the instance don't forget to backup any objects you may want

The listener is just a virtual network name and ip which through ssms will connect you straight to the primary replica\instance.

You'll then see what your account grants you access to

Now,...

The listener is just a virtual network name and ip which through ssms will connect you straight to the primary replica\instance.

You'll then see what your account grants you access to

Now,...

How many nodes...

And that's exactly what I would expect it to do, you're connected to the primary instance and will see all databases available to you on that instance.

What are you expecting...

jayjj (4/28/2014)

---

For some strange reason, when ever i connect to the Listener name for each AlwaysOn group, it list all the databases which is on the SQL instance, so i...