Viewing 15 posts - 1,111 through 1,125 (of 1,790 total)
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 15, 2008 at 7:15 am
Is this Express Edition? If so, then check out this post - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=739837&SiteID=1
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 15, 2008 at 4:14 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 14, 2008 at 9:46 pm
Straight T-SQL will not fully run in Access directly so, program for Access.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 14, 2008 at 9:39 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 14, 2008 at 9:37 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 10, 2008 at 12:52 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 8, 2008 at 3:10 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 7, 2008 at 1:13 pm
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....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 7, 2008 at 1:09 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 7, 2008 at 1:03 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 7, 2008 at 12:52 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 7, 2008 at 12:44 pm
Just to clarify, are you asking how you can determine if VSS is being used in the backup process that you currently have implemented?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 7, 2008 at 12:41 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 7, 2008 at 10:16 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 7, 2008 at 9:39 am
Viewing 15 posts - 1,111 through 1,125 (of 1,790 total)