IIRC the SQL Server AGENT service login account must have the permissions to the network share, not the SQL Server service login.

BTW, did you try a test restore (or...

I already suggested that as a solution but with...

Sangeeth878787 (11/15/2016)

---

Hi,

I am not into DBA, but I got a task to create view/table to display all the jobs live status to display to Non Technical Team. Could any one...

chrisfradenburg (11/15/2016)

---

We can't empty that file because it has the system objects. That may move the user objects but I'm not sure.

I'm also curious as to why it wouldn't...

Jimmy M (11/15/2016)

---

Oh yes.

In the few reports I have looked at, deep down in the plan there is typically a hash join that is estimating that millions of rows will...

I will assume the problem is because some of that index is on the locked-down file. I don't know if the shrink-file-and-empty-it-process can be used to get all of your...

You still need to provide expected outputs for the given rows you provided.

http://stackoverflow.com/questions/20129001/see-what-data-is-in-what-sql-server-data-file

1) Was the error message you posted the ENTIRE message? If not please provide.

2) What objects exist on the 25MB file?

3) What is tempdb configuration on both servers?

4) Where there...

I'm pretty sure you can't put N'NULL' into the ChangeDate columns. Not sure what you used to...

I didn't reread the thread in detail, but have you checked estimated and actual rows at various points in the query plan to see if something is causing them to...

I agree with Phil.

But here is some psuedocode that may help

select student

from truantstudents

where ts.dayoutofschool > (write a predicate for 30 days prior to today)

group by student

having count(*) in (2,3)

homebrew01 (11/11/2016)

---

One thought. Is there any SQL 2005 syntax or other features that will fail on SQL 2016 ??

For instance, we have some tables with datatype TEXT, which I think...

Just modify log shipping and zip/encrypt the files and move them yourself. Easy-peasy and I have done this at a number of clients over the years (including one that had...

Getting supported RAM up to 128GB is a HUGE deal for most instances, although you did say a small website so this may not be that important.

Binoogle "sql server...