Vivien,

Sorry for taking so long to reply to this. We did actually tier storage and used a cheaper variation for backups but not as cheap as the NAS solution. We...

Is this Express Edition? If so, then check out this post - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=739837&SiteID=1

The permissions are not within SQL Server but at the file level or at the folder where the backup file is located. Typically those permissions are maintained by a Windows...

Straight T-SQL will not fully run in Access directly so, program for Access.

Have you tried right clicking on the replication folder in SSMS then selecting "disable publishing and distribution" to see if that will reset things back to a pristine state. Once...

We had an identical situation when I worked for a SOX audited company. We did end up removing those permissions with no ill effects HOWEVER, I would test that out...

There are some that say you can get pretty decent speed out of the NAS devices but we struggled with one working with the BIG vendor to get it performing...

Being that SQL Server does use Kerberos Authentication I would doubt that it would allow you to use the BUILTIN\Administrator account. While it exists on both servers, it is actually...

If you are able to browse to that path from windows then that will work.

Just a note, but I wouldn't leave that IP posted here if it is valid....

Since you are running 2005, if you have not disabled the default system trace, you can actually use the following query to look at the current information;

SELECT top 100...

There are far too many other stored procedures being executed in there to even allow for a reasonable guess at what the performance problems might be with this procedure.

I...

I always vote to have the group placed under the best manager from the choices available. That way if you get a bad one you can then make the argument...

Just to clarify, are you asking how you can determine if VSS is being used in the backup process that you currently have implemented?

Ok, sadly funny. I am still running the last pre-release (don't ask) prior to RTM and thought I would give that a try to see how that did. Not much...

Have you rebuilt your indexes lately? The swings appear to be a bit extreme but not sure what is going on in your environment. Additionally, it also sounds like there...