I don't think so. DNS entries (or their use thereof) would not be affected by the admin performing a manual switchover or an automatic failover.

I don't want to sound pedantic but...

andreas.kreuzberg (1/9/2014)

---

Hi,

did the user use the same SID? If you use local sql-user, they must use the same SID.

First you can test, if you have orphaned user:

http://www.fileformat.info/tip/microsoft/sql_orphan_user.htm

I hope it will...

Seeing as the mirror is an exact duplicate of the primary database, I can only assume at first look that your conenction strings are a bit awry.

It may be an...

Blind as a bat! Thanks Gail!

BrainDonor (1/9/2014)

---

Your CREATE DATABASE needs to be Dynamic SQL if you're going to pass parameters like that.

Also, if you're trying to create a Database Snapshot then the syntax is a...

If you have databases with a is_cleanly_shutdown status of 1 then the database is effectively invisible to DBCC SQLPERF(LOGSPACE). That is the reaason you cannot see them.

This also happens...

Is it possible your user isn't allowed to view information on the missing databases?

Thank you for your input.

It is looking like the solution lies outside of SQL Server itself so I will be looking at PowerShell as the answer. Once I figure...

Keith Tate (12/11/2013)

---

Do you want to prevent them from dropping objects? If so, you could write a DML trigger to prevent that:http://technet.microsoft.com/en-us/library/ms191524(v=sql.105).aspx. Or you could use the trigger to write...

If it is something...

Try removing the SSMS and then reinstalling it.

Grant Fritchey (12/6/2013)

---

kevaburg (12/6/2013)

---

Grant Fritchey (12/6/2013)

---

kevaburg (12/6/2013)

---

For this sort of thing I would recommend a server-side profiler trace. Don't use the Profiler itself if you intend to trace over...

You are right of course....Gail pointed that out to me as well.....I simply misunderstood the aspects of the log that were backed up and those that were not.

Grant Fritchey (12/6/2013)

---

If...