Results 1 to 3 of 3

Thread: Database move

  1. #1
    Join Date
    Apr 2004
    Location
    Melbourne
    Posts
    144

    Unanswered: Database move

    i've got to move 37 SQL Server databases over to new server. My manager tells me that i have to conduct some "check totals" to make sure that the databases contained exactly the same data from what it was when it got moved.

    Is there some stored_procedure to do this ? to make sure that all the stored procedures, views, tables got move across ?

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    ?????????? Are you kidding me. You detach the databases, then attach them on the new server. There's nowhere for the little data bytes to run and hide. Buy your manager a SQL Server book.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Apr 2004
    Location
    Melbourne
    Posts
    144

    Sanity Testing

    How about sanity testing procedures ?
    Write Count scripts to total database records. Is there literature on these kind of topics in SQL Server ?

Posting Permissions

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