Just had a thought, I could restore a backup from a totally different database over the master....lol

refer to this post as your answer

That MS workaround really works. I created a sproc to do this, I also submitted it as a script.

Thank you for the replies.

-- =============================================

-- Author: Alan Speckman

--...

bumping up this post.

I am wanting to know the current errorlog file size.

EXEC XP_enumerrorlogs

That only gives you the old cycled errorlog sizes.

Archive #DateLog File Size...

I'm no longer with DISA, finished my 5 year contract back in 2013. I don't have anything from my time there to share. The key however to...

which fix are you referring to?

One more place to check is Brad McGehee's website. I forgot about him earlier this morning. :w00t:

http://www.sql-server-performance.com

Glenn Berry is where I go first for performance diagnosis.

He has a query that I am putting here.

-- Find single-use, ad-hoc and prepared queries that are bloating the plan cache...

This helped me, thank you!

Thank you Gail, and everyone for your responses.

Alan.

I was just thinking to minimize code changes, but I think you are right. Its for some developers that were worried about making all the changes, so if I...

A Scalar function is what I decided on. to minimize code change, I can call it getDate and then just change the call from getDate() to dbo.getDate(value), where value...

The logins match on both servers.

Great idea Keith, I totally forgot about that.

Gila, I just read that earlier this morning on page 96, "check for log shipping" of Pro SQL Server 2008 Mirroring, Rober L....

Yes,

I'm thinking it is an either-or situation. I wanted to run Netbackup backups in parallel with the old SQL Native backups, but that is impossible.

I will just have...