GSquared (11/18/2011)

---

Instead of using the Microsoft wizard plans, I have a "DBA" database with configurable procedures in it, that manages all of that for me.

Much more granular control of the...

Welsh Corgi (7/22/2011)

---

Yes, don't ask any questions...

Best answer so far.

GilaMonster - you are best & real monster.

nhphuong76 (7/14/2011)

---

Hi all,

I have problem by transfer logins SQL2008 to SQL2008

Full backup server A and restored server B. I want to remain permission all for users on server A and...

Dubbel check ur directory path and you have to mention .bak in folder so MPL understand which want to delete or suffix incorrectly i.e. .bak. There is option when you...

SQL Agent is handled Log shipping, there's probably a SQL Server Agent job (or a series of such jobs) setup to log ship this database. mpl or look in the...

andersg98 (6/22/2011)

---

In 10 plus years of working with SQL server in enterprise environments I have never seen Windows Automatic Update used to patch critical servers. I am being pressured...

Check the sysmessages table. For instance:

Run this syntax and send a result(more info)

SELECT *

FROM

sysmessages

WHERE error = 50000

i got this error mesg. 18210 and 14421 events in application log.

Jayanth_Kurup (6/23/2011)

---

check the autogrowth setting for the log file in the db , make sure the db backups are compressed , enable database compression to reduce the size of the...

Any other suggestioin regarding LOW SPACE.

THNX

No reason to quick answer, weather i send this question to backup site or other place. thnx for remind.

Hi Again,

I forget to mention that, i have Principle server instance (seperate machine), Mirror Server Instance(seperate machine), AND Witness server Instance(seperate machine), All 3 machine running OS: Windows 2008...

Hi,

that not help me at all. You can see in PrtScr, i cant able to change Listener port or Endpoint name: all come as default setting. I need help to...

Thanks to all.

Special Thanks to Gail Shaw (Gail is best dude)