Results 1 to 14 of 14
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Red face Unanswered: Moved SQL Server to different server

    Our techs moved sql server over to a different server thats solely for sql and now the backups wont work right, they check for the consistency but wont back up the data. Can anyone give some suggestions please

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    What is the path they are trying to back up to?

    What is the error you are getting?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Hi Blindman

    He says he is trying to backup from gcfs01 drive to gcsql drive and the error message he is getting is Device cannot be found

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Sounds to me like he is trying to back up to a network drive that is not connected to the new server.

    Backing up to a network drive is a bad idea, in my opinion. You should backup to a local drive, and then copy the resulting files to a network drive or to tape for archiving.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Changed servers

    he is putting SQL on to a server all its own, so he is moving it from gcfs01 server to gcsql server. Its been functioning and backing up to the gcfs01 server with no problems

  6. #6
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Talking What do you think Blindman

    So what do you think is the issue there


    How are you doing blindman??? btw

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Doing fine, thank you.

    He needs to open up windows exporer and make sure he can access both those drives under SQL Agent's account.

    Again, you should backup your databases to a local drive, referenced by the drive letter. I do not understand what you mean by "he is trying to backup from gcfs01 drive to gcsql drive".
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Jun 2006
    Posts
    8
    If you are trying to move the backup off the server, then backup locally, zip the file and then move the file. You will only need enough free space as large as the biggest backup+the zip file. Backing up to a network drive is much much slower and not as stable as backing up locally.

    I backup all of my databases, zip them, and have them copied to my machine nightly. That way when I come in in the morning I have everything I need to recreate all my databases on my machine.

    Just my opinion.

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by ws5926
    Just my opinion.
    ...and the opinion of every other experienced dba. I don't know of anybody who would recommend backing up directly to a network drive.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by blindman
    ...and the opinion of every other experienced dba. I don't know of anybody who would recommend backing up directly to a network drive.
    Its Ok with me for a few manual "one off" situations, particularly in actual process of migrating to a new machine. I wouldn't recommend it for an ongoing practice, especially not an automated one.

    -PatP

  11. #11
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Talking Ahh I love talking to the Guru's

    You guys are such a great I really appreciate it

    No I was just reiterating what I said earlier, I didnt know if explained correctly or anything. Let me tell him what you guys are saying

    YOUR THE BEST

  12. #12
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    oK Let me make sure I understanfd

    so blind what your saying is instead of backing it up to the server, back it up to a local drive instead????

    says hes getting error messages from the backup tapes..hmm

  13. #13
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I have a scheduled job the backs up the databases to disk in separate subdirectories, maintaining five days of historical data on the local drive. A second step then uses robocopy to archive the new files off to a network drive, where our network administrator uses veritas to back them up to tape.

    You should not backup to a network drive, because you do not want database recoverability to fail due to network failure. Plus, as was mentioned, it is slow.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  14. #14
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Talking Thank You Blindman

    Our Tech is actually going to try it out, hes going to take your advice...HOORAY!!!!!!!!!!!

Posting Permissions

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