Open up services.msc and check what you have listed for SQL Server services. Post a screen...

forumlogger (7/16/2012)

---

I already had 2005 installed with a number of databases on my PC. Someone asked me to look at a database problem they had so sent me a script....

ananda.murugesan (7/14/2012)

---

Hi,

old verision

OS -win 2003 enterprise edition

DB -SQL Server 2000 enterprise edition with sp4

DB Size - 650GB

New version

OS -win 2008 R2 enterprise edition

DB -SQL Server 2008 R2 enterprise edition with...

As vikrantspatil has pointed out you need to ensure beforehand that application compatibility is suitable for SQL server 2008 R2.

The other action i would perform first is to take a...

selectname AS JobName

, SUSER_SNAME(owner_sid) AS JobOwner

from msdb.dbo.sysjobs

or you could join msdb.dbo.sysjobs to master.sys.server_principals like so

SELECTj.name AS JobName

, sp.name AS JobOwner

FROM msdb.dbo.sysjobs j INNER JOIN

master.sys.server_principals sp ON j.owner_sid = sp.principal_id

laddu4700 (7/14/2012)

---

Hi, We are using Litespeed for backups.

User db full backup job failed with below error. Anybody encountered this error. please let me know.

Message

Executed as user: domain\adsi. Microsoft (R) SQL...

GilaMonster (7/14/2012)

---

As I said, SQL column...

JJ-469859 (7/14/2012)

---

I am correct in my assumption that we have to use either a fileshare or shared disk to cast the tiebreaker vote correct? The default setup does not work...

Most of the cluster information is available from the Windows cluster itself, What information do you require?

JJ-469859 (7/13/2012)

---

According to my testing, people are in for a rude awakening with using AlwaysOn Availability groups with the default settings for certain scenarios. For instance, according to my testing...

Which version are you upgrading from?

Backup your database(s) regularly and all of these objects will be backed up 😉

TheSQLGuy (7/12/2012)

---

Security mgr wants to put PGP Whole Disk Encryption on all volumes of one of my SQL 2008 R2 boxes. The databases are already encrypted with TDE, but...

savethytrees (7/12/2012)

---

Run the following queries to find which file was the last one to be copied and which file was the last one to be restored.

The following query will give...

you're welcome 😉