Hi Jason,

Sounds like you require a solid archiving strategy and your suggestion makes sense, but you need to plan this properly and test, as you are planning to "migrate" data...

Hi,

You may want to consider Windows x64 versions to future-proof your environment, as well as SQL Server 2005\2008 x64 edition. Windows x64 editions support higher memory configurations compared to...

Richard McSharry (9/15/2008)

---

Hi,

I remember reading that before launching SQL 2005, MS did some scalability testing with HP flagship servers (can't remember the server name). But the sell was that SQL...

Steve Jones - Editor (9/15/2008)

---

There are wizards for both of these. If you have having issues, post a question on the specific issue. These are used for very different technologies...

Ratheesh.K.Nair (9/15/2008)

---

Hi Experts,

I want to implement clustering for one of our client and i have...

Hey,

Have you considered products such as RedGate Compare for both schema and data comparisons?

http://www.redgate.com

Thanks,

Phillip Cox

hey,

Well, haven't experienced this type of behavior, but very interesting and would like to help.

First question, how much data is being processed now? How often to you update your...

Hi,

It must be installed to use things like DTExec, but you don't have to have the service running.

Thanks,

Phillip Cox

Hi,

The SSIS service is designed to enable the management\monitoring of SSIS packages; it is not necessary that it be running in order to execute a package. Likewise, stopping the SSIS...

Richard McSharry (9/11/2008)

---

I have not had a chance to investigate too much, but do know that long running queries are maxing out the CPU.

Someone else identified that IIS was under...

Richard McSharry (9/11/2008)

---

Hi,

I have inherited the following scenario:

A website that is running on IIS6, ASP.Net system with backend on SQL 2005.

IIS is on one server, SQL on another, both 64-bit...

Umm....strange.

Any other backups running on system or other storage hungry applications?

Hi,

This means your backup device has no more space (e.g. error 112).

Clear some space and you should be good afterwards.

Thanks,

Phillip Cox

Hey,

Have you tested using a mapped drive to path (e.g. net use t: \\path)? Also, can you connect to share from your workstation?

Thanks,

Phillip Cox

Hi,

Here's a template script to get you going:

use msdb

go

select top 10 s.job_id, [name] as job_name, s.description as job_description

from sysjobs s join sysjobsteps st

on s.job_id = st.job_id

Thanks,

Phillip Cox