Viewing 15 posts - 2,881 through 2,895 (of 2,897 total)
Use SIMPLE if going back to the last FULL backup is good enough (usually used in test or light usage environments).
Use FULL if you want the security of...
November 24, 2003 at 10:15 am
Similarly to others here, I back up to another drive, deleting the previous day's backup. After the backup, the network backup copies my backup to tape. I also backup...
November 24, 2003 at 10:07 am
You should be able to add it through Enterprise Manager ...... That's how I do it.
November 17, 2003 at 1:40 pm
Running it from a desktop PC ?? Regularly, or just once ?? If regularly, why not schedule it to run as a scheduled job...
November 17, 2003 at 12:53 pm
I get those memory messages every now & then (different #s each time) .... I think it has to do with my PC, not the server
October 24, 2003 at 2:41 pm
I've installed SP3a on several servers ..... No issues that I'm aware of.
October 24, 2003 at 2:39 pm
Why can't you change the database to bulk-logged or Simple recovery, change type to bigint, then change back to full recovery ?
October 10, 2003 at 9:05 am
I did this with good results when I needed to change the length of a field in a replicated table.
-- Specifically: Drop a table from a publication so it can...
October 6, 2003 at 9:30 am
I needed to drop an article from replication so I could change the length of a field. Here's what I did ..... seemed to work for me. I guess...
October 6, 2003 at 8:55 am
Here's what I just tried, and it seemed to work. There may be some "gotcha's" to this that I'm not aware of.
1) I just scripted out the CREATE...
October 3, 2003 at 10:14 am
I'm in the same boat.
I need to modify the length of a field in a replicated table. After dropping the subscription, the table's check box is visible, but won't...
October 3, 2003 at 9:36 am
Was an AS/400 programmer analyst at a few different places.
Before that:
R & D at Cannondale Bikes
Boring job at a thermometer company
Tool & Die at Pratt & Whitney
Night job making snow...
September 10, 2003 at 1:48 pm
I've come across the same thing .... now I only use the count from EM properties as an approximation. I use select count(*) from either QM or EM if...
September 10, 2003 at 9:37 am
We did something like that ..... Used IBM's MQSeries product to transmit data from the web to AS/400 ........ Maybe IBM's WebSphere would help too...
September 10, 2003 at 9:26 am
I'm not meaning to run the entire snapshot every night ..... just the transactions .... hmmmmm .....
September 8, 2003 at 1:27 pm
Viewing 15 posts - 2,881 through 2,895 (of 2,897 total)