Forum Replies Created

Viewing 15 posts - 46 through 60 (of 70 total)

  • RE: process never stops (Killed/Rollback)

    I lived a simmilar situation a few days ago with Sqlserver 7, the problem starts when the Exchange server went down. A process that executes xp_sendmail hangs up, and there...

  • RE: Backup time increased

    I can't change the net configuration, because this server is accesed by several machines. The main server use a gigabit card, and the destination server a 10/100 card, both connected...

  • RE: Backup time increased

    Thanks for your support!

  • RE: Backup time increased

    I've already run defragmentation processes over certainly tables, as you can see in the original topic, obtaining good results. After this is when i start to note this slower backup....

  • RE: disable debugging on production box...

    By default, SP_SDIDEBUG is granted for execute to public role. Revoke this permission...

  • RE: Backup time increased

    Andy, do you know any tool to check/repair the fragmentation of a full db?

  • RE: Backup time increased

    No, i was think the same, but the network is Ok...

  • RE: Reindex sequence

    Still waiting...anybody can help me?

  • RE: Reindex sequence

    Sorry, i forgot to mention that i'm working over SQL7, i think that this command works only in 2000

  • RE: moving log file to another drive

    Belov, i never try to do this in replication enviroments...

  • RE: moving log file to another drive

    1.- detach db

    2.- move the log file to the new location

    3.- attach especifing the new location of the logfile, using @filename parameter

  • RE: Index pages

    Maybe mi explanation wasn't very clear...i only have the address of a index page that was corrupted, and i need to know which is this index to rebuild it ....

  • RE: Restoring Transaction Log

    You must have in mind when you use the tl backup and restore schema, the issue with the non-logged operations that affects the log backups (Error 4213)

  • RE: Oracle transparent gateway

    Thanks for the help, Antares. When i look at the Event Viewer, i see this error:

    'The library file "infoctrs.DLL" specified for the "InetInfo" service could not be opened....

  • RE: Table backup

    Thanks to all for your help!

Viewing 15 posts - 46 through 60 (of 70 total)