Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Washington DC area

    Red face Unanswered: Server Crashing with Mutiple database

    I got a server that Crashed. My network group was able to get it up and running but it's vary fragile. One of the disk is done. What's the best way to get the my database:tables,views,stored procedured,dts packages, jobs off the bad server without crashing it again? I used the databae copy utility but found out that some of the database are replicated and it wont allow it to copy.


    Just another day in the life of a dba

  2. #2
    Join Date
    May 2003
    Parsippany NJ
    In this situation, migrate data from systables would certainly help.

    tables,views -- Use DTS or select into
    stored procedured -- syscomments
    dts packages -- msdb..sysdtspackages
    jobs -- msdb..sysjobs

  3. #3
    Join Date
    Jun 2002
    Hoffman Estates, IL

    moving databases

    backup/restore by default (without KEEP_REPLICATION) drops replication information. The safest way is to restore from you last backup and recreate the replication.

    If you do not want to run SQL Server on the bad server, you may copy / attach the .ldf and .mdf files, use EM to script the "non-functioning replication", use backup / restore to remove the replication and then edit and run the replication script.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts