GilaMonster (11/28/2012)

---

I would not recommend restoring master to other servers. Not least because you overwrite that server's master DB which you then have to go and restore from its backups...

Could this possibly work:

>> Restore the Master database to another SQL Instance

>> Replace...

Do you want to know which configuration setting was changed?

Are there any other similar messages in the error log?

nhphuong76 (11/27/2012)

---

Dear Admin,

Why belowlog appears in MSSQL log. What transactions system execute ?

MSQSQL 2008 R2

Date ...

Im no Guru but I think this could be Bad Parameter Sniffing

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

Can I assume that my documentation is incorrect then?

From SSC

http://www.sqlservercentral.com/Forums/Topic1287679-146-1.aspx#bm1287938

shohelr2003 (11/27/2012)

---

Actually transaction log file keeps on growing, so my database file also grows which consumes more disk spaces. To make database size smaller, I shrink log file that serves...

arkiboys (11/27/2012)

---

Hi,

Here is the database settings:

There is domainName\users unders security\ logins.

db_owner is NOT checked for database1

Then I go to database1, security\users.

I only see users. Notice that it is not domainName\users....

.

Shrinking a datafile is not a good idea, as many of the other folks here will tell...

Perry Whittle (11/15/2012)

---

this is incorrect, role switching in...

jfogel (11/15/2012)

---

so I guess the answer is to never take the secondary out of stand by/read only unless you are serious. Once it happens and you want to go back...

Guys

Any help/ideas with this? Or pointers in the right direction?

Thanks

Ok

I've verified that the performance counter includes memory for plans allocated through both MPA and SPA by using the below

SELECT [type]

, SUM(single_pages_kb)/1024 AS [SPA Mem, Kb]

, ...

abdsubhani (11/14/2012)

---

Hi all,

In our organisation we are shifting sql server to another system. we are done with that but we are not able to get logins. we need to...