Viewing 15 posts - 2,881 through 2,895 (of 6,216 total)
I think its a harder sell in the development community. I agree its surprising they havent done more to push it though.
Andy
December 4, 2002 at 5:14 am
Just look at whether you need to manually force a shrink, either on a scheduled basis or as needed. Depends on how much add/remove of course. Set the growth to...
December 4, 2002 at 5:10 am
Might want to look at DMO, it has good scripting support. A while back I looked at how to add them using DMO, might give you an idea for a...
December 3, 2002 at 5:16 pm
For now MS newsgroups probably your best bet.
Andy
December 2, 2002 at 4:04 pm
One of the more interesting comments from the audience I'd say. I am curious what effect hardware has on this number. What did you think of the presentation?
Andy
December 2, 2002 at 4:02 pm
Couple things you might consider. Are you compressing before FTP'ing? Or take a look at SQLLiteSpeed for compressed backups. No reason to wait for log shipping, nothing in SQL2K you...
December 2, 2002 at 6:37 am
Sounds good. If others are interested, please post or email me as well. Always have other products that need to be looked at too.
Andy
December 2, 2002 at 6:34 am
Maybe. Hard part is that some discussions are open ended, and in somes even though the original poster got their answer, someone else wants to add a comment.
One thing we're...
December 2, 2002 at 5:54 am
I've been lucky enough not to have to deal with it. Stopping the log reader makes sense, sorta, it cant post transactions into distribution. Stopping/starting the logreader should have no...
December 1, 2002 at 5:30 pm
Interesting. I guess the first thing is to figure out why the job is suspended? If you run as SA does it work? Possibly the snapshot job is still being...
December 1, 2002 at 3:50 pm
We dont have one here yet, probably be early next year before we have more content in that direction. Books Online is not bad, and for getting started the replication...
November 30, 2002 at 2:09 pm
I cant think of a good reason not to use a primary key, but omitting the foreign keys has its place for reducing server load. Having an fkey adds a...
November 29, 2002 at 4:28 pm
I dont, curious to hear what uses people have for it as well.
Andy
November 29, 2002 at 3:04 pm
Recommend starting with Books Online. Its the snapshot you're concerned with, so you have to alter the params for the snapshot agent to select the destination folder and to use...
November 29, 2002 at 5:40 am
Suspended how? Job is disabled? Agent just not running?
Andy
November 28, 2002 at 11:40 am
Viewing 15 posts - 2,881 through 2,895 (of 6,216 total)