Thanks, I figured it out. The Availability Group was the problem. I removed the databases from the AG and ran a backup and free space went back up to 99%.

GilaMonster (9/3/2015)

---

http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

Switching to simple recovery will only do anything if the cause of the logs not truncating was the lack of a log backup. If that was the cause, then...

Another thought, which I just tested is to switch the databases to simple recovery and then back to full. Which seemed to work for on of my test db's.

The failover script is easy and there are a lot of options for detecting whether or not a server is back online. The problem is going to be how do...

rocky123 (8/25/2015)

---

i am trying to add another replica but I am getting error 19456....thank you for help

Create failed for Availability Group Listener 'AO-AGL'

None of the IP addresses configured for the...

It'll work fine. Are you unable to add DR2 as another Replica? You can have up to 8 replicas.

GilaMonster (8/20/2015)

---

It's not log shipping you need the memory for, it's when your primary fails and you have to switch over to the secondary to keep the app running. The...

This is a great tip, thanks.

Grant Fritchey (8/4/2015)

---

You're better off doing custom scripts. MERGE can, and does, function. But, it's not very tuneable. You get a single execution plan for the INSERT/UPDATE/DELETE regardless of which...

Can you also provide more information?

Do the backups all run at the same time?

How large are the databases? Are some 5 GB and others 100 GB?

Are there databases with large...

Lack of IFI and slow network will kill your restore speed. Curious though, how long does it take to run a backup?

You should also see a pretty substantial restore time...

Igor Micev (7/29/2015)

---

JoshDBGuy (7/29/2015)

---

Igor Micev (7/29/2015)

---

Hi All,

Thanks for replying.

Issue is resolved.

The ssd disk has been going working worse and worse. Its response time has been changing in the last couple...

From books online

If the database being restored does not exist, the user must have CREATE DATABASE permissions to be able to execute RESTORE. If the database exists, RESTORE permissions default...

Igor Micev (7/29/2015)

---

Hi All,

Thanks for replying.

Issue is resolved.

The ssd disk has been going working worse and worse. Its response time has been changing in the last couple of weeks having...

I would use tracert, ping, and pathping to look for performance issues. This sounds like a network problem, it's not going to be super easy to diagnose.

I would also...