Viewing 15 posts - 421 through 435 (of 1,790 total)
You should have Performance Monitor on your machine. You would open that and remove the counters that are currently running. Then in the drop down you will want to put...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 11, 2011 at 10:29 am
You should really watch the Checkpoint Pages / Sec performance monitor counter and see if it drops off. If it is running all the time or for really long periods...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 11, 2011 at 10:15 am
I use FaceBook but overall don't find it profitable. More than anything I find it concerning for the next generation that don't know how to communicate in any verbal form...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 6, 2011 at 7:41 am
It's not that virtualizing is a bad idea or that people on the forum don't support it. 🙂 The post is indeed long and the questions are probably something that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 22, 2010 at 2:39 pm
dajonx (12/22/2010)
Yes, I am using the native SQL Server backup and restore. I am testing out LiteSpeed and I really like it. 😀 Now... To just...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 22, 2010 at 12:25 pm
Grant Fritchey (12/22/2010)Maybe a bingle search.
This is new to me. I've got to get out more....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 22, 2010 at 12:07 pm
You could try this (pulled from HERE);
select
database_id,
file_id,
io_stall,
io_pending_ms_ticks,
...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 22, 2010 at 12:04 pm
Is it potentially trying to do a verify on the backup and the backup to tape is reading it at the same time? Serious guess so take it with that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 22, 2010 at 11:38 am
dajonx (12/22/2010)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 22, 2010 at 11:24 am
You can BUT I would strongly recommend that you use the procedure I pointed out to build them. That will build them to match the publisher (and hopefully the subscriber)....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 22, 2010 at 7:11 am
saidapur_satish (12/21/2010)
Hi,Are you sure LAST DIFFRENCIAL backup only....
Yes, differential backups are cumulative in that they hold all the changes since the last full. So, you do...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2010 at 1:38 pm
saidapur_satish (12/21/2010)
I have Doubt....
I am taking Full backup every st of month, then taking a differential backup every day & transaction backup going on every...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2010 at 1:30 pm
restore with full backup norecovery, restore differential from the 22nd or 23rd depending on when the differential occurs with no recovery, restore all the log backups following the differential backup...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2010 at 1:27 pm
Not sure that I helped in this case but.... 🙂
If you do think of a reason that you have to reinitialize give a shout - prior to starting the work...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2010 at 12:00 pm
If you have time please update this thread as you have more information. I would be curious to see what you find as you start looking at the counters.
The...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2010 at 10:14 am
Viewing 15 posts - 421 through 435 (of 1,790 total)