Viewing 15 posts - 46 through 60 (of 1,790 total)
Did you set your retention low enough in the SnapManager Configuration utility?
One note here, but from what I understand SnapManager for SQL Server is on the way out and...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 12, 2012 at 10:38 pm
Nate - I ran into the same issue with adding / removing databases and posted a thread on the NetApp forums. I did receive a couple responses on how to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 6, 2012 at 12:39 pm
We deploy database changes separately from code changes and allow for a layer of abstraction. The benefits here are tremendous although there is a more complicated framework that has to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 30, 2012 at 8:47 am
Great. Glad that worked. If that wasn't the issue I was going to be hitting the "stumped" button pretty quickly. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 15, 2012 at 8:30 am
Ok, since you are not seeing anything on the subscriber, we need to make sure that you are indeed sending it to the correct subscriber. You will need to expand...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 15, 2012 at 8:07 am
In SSMS connected to the Publisher, expand Replication, Local Publications, Select the publication you are referring to and expand, right click on the subscription select "View Synchronization Status" and let...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 15, 2012 at 7:39 am
My pleasure. I'll look forward to hearing your findings in the future.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 14, 2012 at 9:56 am
I'm sure you stopped some process that was running - which is a good thing. 🙂
I would recommend doing some logging via a system level trace or logging of...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 14, 2012 at 9:44 am
Excellent news. Get DAC configured now too. 🙂 http://ask.sqlservercentral.com/questions/1770/enable-dedicated-administrator-connection.html
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 14, 2012 at 9:16 am
Most likely it is trying to complete some process that was running prior to the stop request and may be doing a rollback. Without insight into what queries were running...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 14, 2012 at 8:43 am
Let me know when it comes back.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 14, 2012 at 8:32 am
No, let it stop, don't kill the process. It will eventually stop.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 14, 2012 at 8:15 am
Yes, if you don't have DAC configured and no access to SQL Server then you have to restart the SQL Server service, unfortunately.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 14, 2012 at 8:05 am
To get a TRUE view into how much memory SQL Server is using I would recommend reading this post - http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/08/24/troubleshooting-the-sql-server-memory-leak-or-understanding-sql-server-memory-usage.aspx
For a server with 8 GB of memory I would...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 14, 2012 at 7:47 am
You should always have a max server memory setting to ensure that you don't starve the OS. There are varying opinions on how much you should leave. How much do...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 14, 2012 at 7:30 am
Viewing 15 posts - 46 through 60 (of 1,790 total)