Viewing 15 posts - 586 through 600 (of 1,790 total)
Do you have access to the SQL Server 2005 tools in 64-Bit format? That would be the way to go. Aside from that, wasn't SQL Server 2000 only released in...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 11, 2009 at 11:51 am
Yeah, sorry I wasn't clearer earlier but the dependency issue is what I was trying to convey. Sorry about that and glad you were able to figure it out.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 11, 2009 at 10:18 am
Is this a cluster and is that drive a resource dedicated to that instance? If not then it can't use it / see it.
Aside from that I have no...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 11, 2009 at 9:04 am
I did not include that in this design but could look into that as well.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 2, 2009 at 8:22 pm
Wayne,
My guess is that the only place you will see the savings is in the compile time. Run both options with the SET STATISTICS TIME ON and see what...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 28, 2009 at 9:51 pm
sdoughty (5/28/2009)
We're looking at archiving, and I came across this product from HP. We've got one large-ish database (is 400GB large?), which is performing fine transactionally, its just the maintenance...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 28, 2009 at 9:43 pm
Jeffrey Williams (5/28/2009)
PaulB (5/28/2009)
Here is how you do it.
1- Pre-create the database in your "target" server -so you make all decisions about storage.
2- Force-restore over the pre-created database -so datafiles...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 28, 2009 at 4:51 pm
PaulB (5/28/2009)
David Benoit (5/28/2009)
Can you backup to and restore from the external hard drive? If so, that seems like the safest and least painful way of doing this.
:w00t: flashback!
Brilliant...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 28, 2009 at 3:04 pm
Can you backup to and restore from the external hard drive? If so, that seems like the safest and least painful way of doing this.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 28, 2009 at 12:14 pm
oraculum (5/27/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 27, 2009 at 6:15 am
Jonathan Kehayias (5/27/2009)
Brian Munier (5/27/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 27, 2009 at 6:12 am
sunny1_liu (5/27/2009)
In recent days,I also find if the filters are limited only at one side as:
" WHERE [DayID]>= convert (nvarchar(10),DATEADD(month,-2,GETDATE()),112);"
...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 27, 2009 at 6:10 am
Hard to say but if it is clearly missing records in your destination table then for some reason the replication filter is sending updates for records that are not present....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 22, 2009 at 8:55 am
You can do a couple of things, first would be to reinitialize so that you repush the snapshot. This is the cleanest approach and would be my recommendation.
If that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 22, 2009 at 5:59 am
Alvin Ramard (5/21/2009)
jcrawf02 (5/21/2009)
David Benoit (5/21/2009)
Lynn Pettis (5/21/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 21, 2009 at 9:44 am
Viewing 15 posts - 586 through 600 (of 1,790 total)