Viewing 15 posts - 811 through 825 (of 1,790 total)
Any errors in the SQL Server Log or the application / system log for Windows? Very curious.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 11:39 am
I would start with this link which is really BOL. I think you will find it to be pretty straightforward.
One note though, when they are mentioning using another server...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 11:36 am
Sorry, just trying to understand a bit though, are you getting complaints about performance as part of the audit data collection or as part of the "reporting" of that data?...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 10:48 am
Pro's - active queries aren't slowed down as the original index is still in place. So, activity can continue as "normal" during the rebuild process (for the most part).
Con's -...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 10:46 am
There is a really great blog post by Kimberly Tripp here and here. It would be worthwhile to read these and consider the things that are stated. Most times people...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 10:42 am
Sorry, should have included this with previous reply - From BOL;
There are two options for configuration when you place the secondary database in standby mode:
You can choose to have...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 9:39 am
sunny Brook (2/6/2009)
stimpy2300 (2/5/2009)
2. What performance hit will the production server take if I do the hourly log shipping?
If you do hourly log-shipping, the DB on your Reporting server...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 9:24 am
Check out Paul Randal's blog about corrupting a database....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 6, 2009 at 8:08 am
Rajesh kasturi (2/5/2009)
CSS SQL Server Engineers post is very useful
Yeah, those guys seem to know what they are doing. 😛
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 5, 2009 at 9:06 pm
Check out this blog post from the CSS engineers. I think it will give you everything you need to check and go farther if you need.
Not sure if you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 5, 2009 at 8:35 pm
The production server will only incur a small hit with the log backups but that will provide you with better protection throughout the day and will eliminate the possibility of...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 5, 2009 at 2:03 pm
Then exercising hourly log backups may be the way to go and use that for log shipping to the other server. Have the logs applied at night and allow for...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 5, 2009 at 1:50 pm
When you switch the database to full recovery model you need to implement a proper backup plan for the transaction log to keep the log file size manageable. However, with...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 5, 2009 at 11:11 am
From BOL:
------------------------------------------------------------------------------------------
The Snapshot Agent performs the following steps:
Establishes a connection from the Distributor to the Publisher, and then takes locks on published tables if necessary:
For snapshot publications, locks are held...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 5, 2009 at 9:50 am
So, when you look at the output of sp_spaceused is the output not what you expect for data structures and index structures?
Might be wise to take GSquared's advice as...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 5, 2009 at 9:38 am
Viewing 15 posts - 811 through 825 (of 1,790 total)