fusion

Very good question - imho.

Jeff Moden (7/21/2014)

---

Mac1986 (7/21/2014)

---

I created a job with a step which has OperatingSystem(CMDEXEC) and run as DOMAIN\MYACCOUNT.

SQLCMD -q "SQLOPSDB.DBO.sp_now"

But now the job is not finishing as the above...

Jeff Moden (7/21/2014)

---

Getting back to the original problem, if you had 2000 log files over the week and did, say, daily DIFs, would you actually delete the log files covered...

Do the users need to be able to change the schedule of existing jobs or do they need to be able to kick off the job (some people refer to...

Jeff Moden (7/21/2014)

---

Jack Corbett (7/21/2014)

---

SQLRNNR (7/21/2014)

---

I am a bit surprised this hasn't been asked yet and it seems REALLY important.

Why do you have 2000 log backups to restore?

If...

Lynn Pettis (7/21/2014)

---

Issues.

Three, and I may be wrong here, but you are going to be pulling the data from all the tables referenced across your network to the server running...

ChrisM@home (7/21/2014)

---

Lynn Pettis (7/21/2014)

---

So you are saying the Linked Server is hidden by using a synonym? Well, not obvious from what you posted....

smtzac (7/21/2014)

---

Thank you Shawn for your reply. I am bit confuse here, when I run your query I get total no. 97 (when i add all) but when I run...

I am a bit surprised this hasn't been asked yet and it seems REALLY important.

Why do you have 2000 log backups to restore?

If you truly have that many log backups...

Jeff Moden (7/21/2014)

---

As a bit of a sidebar, if the MSDB database is still intact, you can use the GUI to do file level restores (it's pretty smart and will...

Is SQL Server the only thing installed on this box?

Are you using Fulltext search by chance?

Do you have CLR procs deployed?

Do you have SSRS or SSIS running on this box?

Is...

Why?

They are already only using 50% of the memory allocated to the server. 8Gb available and 4GB set for max...

I agree. Especially if...

Welcome Back

http://bit.ly/welcombak