Viewing 15 posts - 1,276 through 1,290 (of 1,583 total)
Agree wth George...go through the Wizard to set up a small test replication (shouldn't matter which type), replicate one table. After you've done that, undo it all. This...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 6, 2011 at 2:10 pm
Can you post the execution plans for both queries?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 6, 2011 at 2:04 pm
100% Agree with Ninja, the locking hint would be useless (and is generally frowned upon)
At our company we have a lot of reporting running off data from MSSQL and...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 6, 2011 at 11:35 am
I'd recommend Idera's SQL Diagnostic Manager, very configurable and has a BUNCH of great tools
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 6, 2011 at 10:55 am
You ONLY needed to copy and restore the last differential that ran before the next full backup, not all of them. Differentials are cumulative.
Gail, I have to ask...
Say I...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 6, 2011 at 9:40 am
I assume you're using a linked server....can you post the SQL statement please?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 5, 2011 at 11:24 am
Thanks Gail, I will remember this going forward
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 4, 2011 at 9:55 am
Yes I had copied them all but it would let me restore the latest one as it was created after a new full backup, so I only restores the diffs...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 4, 2011 at 9:13 am
I believe this has been resolved. Thanks to everyone who helped with the solution...just another reason why I simply LOVE this website...you guys (and gals) ROCK 😀
I pulled the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 3, 2011 at 6:39 pm
Gail, yes, if that were an option I would have done that before placing this post :hehe:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 2, 2011 at 3:29 pm
About 300 miles
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 2, 2011 at 2:51 pm
Again, it will take 18 hours to copy a full backup up to the our DR location (due to it's size - 88GB compressed via Hyperbac)...during this time a FULL...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 2, 2011 at 12:42 pm
I understand but still seeking clarification on:
If I restore the full backup, then apply the last differentials to the secondary server AND a new full backup occurs on the primary...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 2, 2011 at 12:00 pm
You mean restore the latest differential backup over the secondary DB, right?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 2, 2011 at 11:34 am
GilaMonster (12/2/2011)
MyDoggieJessie (12/2/2011)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 2, 2011 at 10:46 am
Viewing 15 posts - 1,276 through 1,290 (of 1,583 total)