Forum Replies Created

Viewing 15 posts - 181 through 195 (of 307 total)

  • RE: the sql learning method

    MY suggestion = Go to microsoft.com and down load a trial copy of SQL Server. . Read the install guide and go through setting up your own database. Make sure...


    John Zacharkan

    March 24, 2003 at 1:59 pm

    #451965

  • RE: Log Shipping

    The question really is, can you restore a backup from SQL 7 to 2K ? That's all log shipping does - no magic.

    John Zacharkan


    John Zacharkan

    March 24, 2003 at 1:42 pm

    #451960

  • RE: Help! Problem in Log shipping !

    The production server does nothing other than generate transaction backups. Drop your transaction logs on the production server.

    SQLServerAgent on the stand by server should be started with an...


    John Zacharkan

    March 24, 2003 at 11:50 am

    #451934

  • RE: Sanity check on an upgrade

    All paths are the same. Agree on patching up before replacing the master.

    Thanks Steve.

    quote:

    are all the paths the same? I...


    John Zacharkan

    March 24, 2003 at 7:07 am

    #451861

  • RE: 3rd Party Log Backup Problem

    If you are using ARC with the SQL Server hook/add on installed then you shouldn't be backing up the .ldf directly.

    Your only other choice to backup up the...


    John Zacharkan

    March 20, 2003 at 1:58 pm

    #451625

  • RE: Log shipping VS Replication

    It'll work over a 56K line as long as the connection is available at the time of replication.

    quote:

    But I would like...


    John Zacharkan

    March 20, 2003 at 12:14 pm

    #451613

  • RE: 3rd Party Log Backup Problem

    Sounds like you're using offline TSM or ARC Server backups. When the backup software is setup it looks at dir/sub dir and files that you want to backup.

    The file...


    John Zacharkan

    March 20, 2003 at 12:10 pm

    #451611

  • RE: Installation problem

    Hey anybody who can do the time warp can admin SQL Server, why do you think those Oracle people get so hot under the collar.


    John Zacharkan

    March 13, 2003 at 9:33 am

    #451009

  • RE: Installation problem

    Ok here are the steps that corrected my problem

    1. Disable IISAdmin, INTEL NMS, and TSMSched.

    2. Driver signing is a new feature for Win2K....


    John Zacharkan

    March 12, 2003 at 3:02 pm

    #450918

  • RE: DBCC SHOWCONTIG

    Try

    DBcc showcontig (30)

    quote:

    I think the problem is in here:

    Logical Scan Fragmentation ..................: 0.00%

    Never saw a % so low. I guess it...


    John Zacharkan

    March 12, 2003 at 1:41 pm

    #450907

  • RE: DBCC ShrinkDatabase in a full-recovery database

    Let me take a stab at this, I'm not a SQL 2K guy yet. Full recovery mode simply means that every single transaction on the database is recorded and the...


    John Zacharkan

    March 12, 2003 at 1:24 pm

    #450905

  • RE: DBCC SHOWCONTIG

    Good

    quote:

    So is that good or bad?

    John Zacharkan


    John Zacharkan

    March 12, 2003 at 1:15 pm

    #450904

  • RE: Exclusive Access

    If you're trying to do this from QA, make sure you're not sitting in the database that you want to rename. That's alway good for a laugh make sure that...


    John Zacharkan

    March 12, 2003 at 9:10 am

    #450878

  • RE: DBCC SHOWCONTIG

    It would depend on what that table would be used for. If it's a pure look up table it looks great. It's a heavy transactional table you sequentialy add transaction...


    John Zacharkan

    March 12, 2003 at 8:29 am

    #450874

  • RE: Installation problem

    Thanks for replying Bill,

    I have tried it several time on two different boxes, stage and prod, I have also tried using two different copies of the install software, the...


    John Zacharkan

    March 12, 2003 at 8:09 am

    #450871

    • Viewing 15 posts - 181 through 195 (of 307 total)