Forum Replies Created

Viewing 15 posts - 2,881 through 2,895 (of 2,897 total)

  • RE: Backing up Tran Log

    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...

  • RE: where do you have your backups go?

    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...

  • RE: RE: Add new tables for replication

    You should be able to add it through Enterprise Manager ...... That's how I do it.

  • RE: Running DTS From SQL Server

    Running it from a desktop PC ?? Regularly, or just once ?? If regularly, why not schedule it to run as a scheduled job...

  • RE: SP3 memory error

    I get those memory messages every now & then (different #s each time) .... I think it has to do with my PC, not the server

  • RE: Issues with SP3a

    I've installed SP3a on several servers ..... No issues that I'm aware of.

  • RE: Changing a column from INT to BIGINT - Urgent

    Why can't you change the database to bulk-logged or Simple recovery, change type to bigint, then change back to full recovery ?

  • RE: Dropping a replicated table

    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...

  • RE: i want to UnPublish one article from Replication

    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...

  • RE: remove publisher table

    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...

  • RE: remove publisher table

    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...

  • RE: What did you do before SQL?

    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...

  • RE: EM and QA show different counts

    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...

  • RE: SQL Server and AS/400

    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...

  • RE: Trans Repl: Could not bulk copy error

    I'm not meaning to run the entire snapshot every night ..... just the transactions .... hmmmmm .....

Viewing 15 posts - 2,881 through 2,895 (of 2,897 total)