SQL SERVER BACKUP
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: SQL SERVER BACKUP

  1. #1
    Join Date
    Jun 2001
    Location
    vienna
    Posts
    19
    hi,

    does somebody knows a script to do an backup from a sql server 7 manuel??

    thanks for your help,

    the kid.

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    hmmm ... wow, I was wrong for so long, isn't this forum an Oracle one ???

  3. #3
    Join Date
    Jul 2001
    Location
    Netherlands (Utrecht)
    Posts
    21
    I think it is a Oracle forum...

    I defently think so...
    J.Jongman - DBA

  4. #4
    Join Date
    Jun 2001
    Location
    vienna
    Posts
    19

    wow

    hmmmm.... wow, i was wrong for so long... i thougth you guys here were helpful... i'm a idiot...


  5. #5
    Join Date
    Jul 2001
    Location
    Netherlands (Utrecht)
    Posts
    21
    I'm Sorry,
    But most people here are Oracle dba'ers and not SQL server dba'ers...

    I realy want to help you but I realy don't know any thing about sql server, my expertice is Oracle db's..
    J.Jongman - DBA

  6. #6
    Join Date
    Apr 2001
    Location
    London
    Posts
    725

  7. #7
    Join Date
    Jun 2001
    Location
    vienna
    Posts
    19

    thank you

    thank you.

    the kid

  8. #8
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    BTW - sqlmag.com, usually takes about 2/3 days for registered users to respond, it is also subject to performance problems and downtime - Microsoft through and through.. He He.

  9. #9
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    PMJI:
    I do both Oracle and SQL Server.

    I assume you are asking how to do a manual backup in SS7.

    I do:

    sp_detach_db dbname
    (in a dos or other window copy the db datafiles)
    sp_attach_db dbname,data_file_name,log_file_name


    Note: get the file names before the detach. It makes life simpler than trying to find them on a large server.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  10. #10
    Join Date
    Jun 2001
    Location
    vienna
    Posts
    19

    Thumbs up

    Thank you...

    Have a nice weekend to all.

    The kid.

Posting Permissions

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



Click Here to Expand Forum to Full Width