monamym (2/28/2016)

---

Hi all,

I have a question , imagine a server that we didn't implement it as standard and now we want to move it's file to other drives to make...

has someone changed the run as on the job step maybe?

running as the virtual NT SERVICE account is not recommended for services that require network access, what has changed since...

travisrunyard (2/29/2016)

---

I've already ready that and just about everything else on google about this topic. This doesn't help as this basically tells...

bubby (2/29/2016)

---

I just need help to get a proper query with which I can generate the report for direct users connecting to my SQL instance,

Is there any way to see...

check sysprocesses and hard line is kill the users spid.

Otherwise call them and ask them to rescind their connection\session

gorripativ (2/26/2016)

---

Hi,

I have set my db log intitial size as 512 MB and autogrowth as 512 MB. The db is in full recovery model and tlog runs every 15 min....

check this first see if it helps

http://blogs.msdn.com/b/sambetts/archive/2014/02/04/multi-subnet-clustered-sql-registerallprovidersip-sharepoint-2013.aspx

Firstly check the state of the primary database and report back on that.

also check the results of this query run against the primary and secondary

select name, differential_base_lsn, differential_base_time from sys.master_files

where...

ramana3327 (2/24/2016)

---

Hi,

Is it possible to find which vmware version we are using from SQL Server or from windows?

Whn I run @@version

I received the result Microsoft SQL Server 2014 standard...

kevaburg (2/24/2016)

---

It was the typical "15 seconds for IO" message that I associate with contention. What bothered me the most is that within the Task Manager only one datafile...

please don't double post, see my reply here

http://www.sqlservercentral.com/Forums/Topic1763576-1549-1.aspx?Update=1

lw1990 (2/23/2016)

---

Hi,

I have a log shipping process set for a long time and the restore step is failed on the secondary server while the backup step from the primary...

preferred node is just a terminology. It's only considered by the auto failback option in the cluster if it's enabled.

From the design and licensing standpoint, if you're not running the...

techtnt-630432 (2/23/2016)

---

Hi all,

I've been presented with the challenge of handing a migration from our current SQL 2012 Web (64 bit) edition (Windows Server 2012 R2) to our new 2014 Enterprise...

please start by posting results of the following query

select 'Table [' + object_name(i.object_id) +

'] has index [' + i.name +

'] on partition scheme [' + ps.name + ']'

from...