i take it this won't work if you have SSIS packages stored in the file system?

Paul Randal (5/9/2010)

---

Hmm - there are some nasty potential problems with doing what you describe and I would not recommend it in production:

1) what if the clustered index being rebuilt...

can someone give me a real world example of when this would be used in production? i've never seen it used, but it could be because a lot of our...

i would do the 2008 exams since they will have a longer life

make sure the account under which SQL is running has lock pages in memory rights. in your sql server log you might be seeing errors about the memory being flushed.

i...

depends on the actual workload per query, but it sounds like you have too much machine

i'm assuming you're running the x64 version of the OS and SQL

how much is the workload? how many queries per day are handled?

my favorite way to do this is by SSRS. it's overkill but i hate making the result set of database mail look nice.

is the server running out of CPU/RAM, etc? if you can, i would first buy more disk to split up the I/O if it hasn't been done yet

thx

going to have to try this to see how it works

edit: does this work with DTS packages? we have a lot of jobs that are DTS or SSIS packages and...

Solomon Rutzky (5/4/2010)

---

alen teplitsky (5/4/2010)

---

nice article

we have a 2TB database we're going to be moving to new hardware soon ... but there is no way to test it since we...

nice article

we have a 2TB database we're going to be moving to new hardware soon and i wanted to try to partition it because people seem to like to select...

netbackup, backup exec or commvault are the big backup applications

there is also disk to disk, but i still prefer tape and it's a lot cheaper

river1 (4/30/2010)

---

How can i implement a thing like that? so that only the company (across AFRICA) can use it?

At this moment we put the files in a FTP Server, but...

My backups go straight to lto-4 tape. Don't know if it's as good as windar, but for the price of tape it's unbeatable