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...
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.
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...
June 11, 2009 at 9:04 am
I did not include that in this design but could look into that as well.
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...
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...
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...
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...
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.
May 28, 2009 at 12:14 pm
oraculum (5/27/2009)
May 27, 2009 at 6:15 am
Jonathan Kehayias (5/27/2009)
Brian Munier (5/27/2009)
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);"
...
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....
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...
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)
May 21, 2009 at 9:44 am
Viewing 15 posts - 586 through 600 (of 1,790 total)