bpowers (3/17/2015)

---

We are looking at upgrading our SQL Server 2008 SP4 Standard Edition instances to SQL Server 2012 SP1 Enterprise Edition. Has anyone experienced any issues doing such an upgrade?...

GARY lAUNDRY (3/6/2015)

---

One of my programmers changed their database from full to Simple recovery. Saw that my job that backs up the Full Recovery mode databases failed, so I moved...

S_Kumar_S (3/4/2015)

---

Hi All

I have an application server APP1 in Domain DOMCORP. Then there is another SQL Server machine in DOMCORP domain. The SQL Service is running with Local system account.

When...

ericwenger1 (3/5/2015)

---

I need to be able to see if the incoming csv file had a head row different than the previous files header row. That will tell me that I...

sqlfriends (3/6/2015)

---

We have a in house developed application and database. It is online transaction database for student school assignment.

Size is about 6 GB.

We have another department needs our data for...

udaynov17 (3/5/2015)

---

Hi

I have been looking around for Migration Checklist and the below is the procedure suits ideal for environment.

Pre-Migration CheckList:

Assuming the applications supports the SQL Version...

Try using backup and restore.

sql-lover (2/26/2015)

---

S_Kumar_S (1/28/2015)

---

After having spent some 13 years with SQL Server and being a Sr. DBA for years, today I just thought of having opinion of other Sr. DBA on...

Someone replied you in other site, http://www.lawebdelprogramador.com/foros/Microsoft-SQL-Server/1479004-Cluster-SQL-Server-2008-R2-Activo-Activo.html

https://msdn.microsoft.com/en-us/library/ms143504.aspx

Did you try restoring using single-user mode?

Dave Mason (2/23/2015)

---

I've created an automated DR test to test my backups. It restores databases to a test/sandbox instance of SQL. After...

ramana3327 (2/24/2015)

---

Hi,

Currently, working with SQL backups.

I am looking for the route cause of slow backups. Our current environment is 208R2. We have a database around 450GB. Our current backup...

andersson_par (5/3/2013)

---

SCOM it is!

To make this work use a service account to run the scom agent service with this:

Member of "Performance Monitor Users" local group

Member of "Event Log Readers" local...

I suggest to do a 'Remove node' first on passive node.

Did you try running "Run as administrator"?