Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2004
    Posts
    93

    Talking Unanswered: is this the best way to backup more than one database

    I am setting up a DTS so that we can backup each of the database, is this the best way to back up each of the mdf & ldf files to another server? cheers

    EXEC sp_addumpdevice 'disk', 'cc_150_chg', '\\homer\db_backups$\cc_150_chg.mdf'
    EXEC sp_addumpdevice 'disk', 'cc_150_chg_admin', '\\homer\db_backups$\cc_150_chg_admin.mdf'
    EXEC sp_addumpdevice 'disk', 'cc_150_chg_Log', '\\homer\db_backups$\cc_150_chg_log.ldf'
    EXEC sp_addumpdevice 'disk', 'cc_150_chg_admin_log', '\\homer\db_backups$\cc_150_chg_admin.ldf'
    EXEC sp_addumpdevice 'disk', 'cc_153', '\\homer\db_backups$\cc_153.mdf'
    EXEC sp_addumpdevice 'disk', 'cc_153_log', '\\homer\db_backups$\cc_153.ldf'
    EXEC sp_addumpdevice 'disk', 'cc_153_admin', '\\homer\db_backups$\cc_153_admin.mdf'
    EXEC


    This will form part of the step in 'command line'?

    Cheers
    E
    Cheers
    Etravels

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Why don't you just backup to a file?
    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
    Posts
    93

    How?

    backup all the database to a file? How can I do this? also do i need to specifiy all the databases individually by backuping both mdf & ldf files?
    Cheers
    Etravels

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Backup each database to a separate file. You don't need to back up the log files (ldf) unless you need point-in-time restore.
    If it's not practically useful, then it's practically useless.

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

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    [ahhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh]


    Quote Originally Posted by blindman
    You don't need to back up the log files (ldf)

    [/ahhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh]

    You're fired
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Feb 2004
    Posts
    93

    ta

    alll sorted!!!!1thanx
    Cheers
    Etravels

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    OK Brett, YOU explain the whole concept of log files to him! I got actual work I gotta do today.

    ...or just point him to Books Online...

    If it's not practically useful, then it's practically useless.

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

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by blindman
    OK Brett, YOU explain the whole concept of log files to him! I got actual work I gotta do today.

    ...or just point him to Books Online...


    Settle down....

    Hey, there's a first time for everything, too

    OR, I could just post Tara's blog

    http://weblogs.sqlteam.com/tarad/category/95.aspx

    I think I've stolen most of that...

    Let me ask....when was the last time, aside from testing contingency, that you had to do a restore, and have to reapply all of the logs?

    I don't remeber...had to be 6.5
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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