Thank you for the information Lowell.

Charlie

Thanks Slammer.... I actually tried to contact Microsoft support... but they wanted credentials... I then "Googled" and found the same information as you sent in your post. I was just...

Thank you for the information. I actually did post in the 2014 forum.... but did not get a reply.... thought maybe the "New to" section may get a reply. I...

I tried to use SSMS 2014 maintenance plans to backup databases I am testing in an Availability group. I am failing badly.

I have the Availability Groups set to "Prefer Secondary"...

Thank you... this information is very helpful. I will discuss with my manager at my One on One today.

WHDProd2408.30577.051090

select name, log_reuse_wait_desc from sys.databases

WHDProdLOG_BACKUP

No active open transactions.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Hi Gail.... thanks for the article. I read it and I think the section that applies to my issue is:

If this log...

I actually tried to shrink the Log file.... no go.... then set to SIMPLE.... then shrink.... no go...... then issue a CHECKPOINT..... no go.... so I detached.... renamed log file.......

Thanks for the information. I was actually able to get the Log to shrink back to 4,750 MB by lowering the Initial Size and issuing a CHECKPOINT. My guess is.......

A 15 GB Log file seems very large for a 22 GB database... Especially in SIMPLE mode.

Thank you very much!

Charlie

Grant,

I found the issue thanks to your input.... the Schema was pointing to the Service Account as the owner instead of the correct owner.... made the...

It was a straight migration.... I installed a new installation of SQL Server 2008 R2 on a new server... added SP2. Then backed up the database from the SQL Server...

Good Morning Sean and Grant,

I am not a SQL Developer.... so I am going on what my Developer is showing me. I migrated a SQL Server database from...