Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2003
    Posts
    7

    Question Unanswered: Help How Make Backup and Restore ?

    Hi all. I'm newbie user of sqlserver 7.

    I need make Backup from specific tables of my database and my application send this file by mail to other users that restore this information in yours Database.

    How i can do it (i dont know the specifics commands to backup and Restore)

    Other question

    if I only backup the log file and restores this in other database
    I'll have the same information in all users ?

    Help me please

    Thanks in Advance

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Check BOL on the syntax. You can place your specific tables on filegroups and have your users restore those filegroups after initial full db restore.

  3. #3
    Join Date
    Aug 2003
    Posts
    7

    Help How Make Backup and Restore ?

    Check BOL on the syntax. You can place your specific tables on filegroups and have your users restore those filegroups after initial full db restore.


    Excuse me, but i don't understand what is BOL. ?

    How i said i'm newbie.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Books
    On
    Line

  5. #5
    Join Date
    Aug 2003
    Posts
    7

    Help How make backup and Restore

    Originally posted by rdjabarov
    Books
    On
    Line
    Thanks, I will Try.

  6. #6
    Join Date
    Aug 2003
    Posts
    7

    Question Re: Help How Make Backup and Restore ?

    I connect like database admin and

    try to make differential backup using this command


    1- Back up Database Cyber to XXX With Differential

    2- Back up Log Cyber to XXX

    The to test the back up

    I run then this restore command

    1- Restore database Cyber from XXX with norecovery and

    2- Restore Log Cyber from XXX with recovery.

    All is perfect

    I close the connection


    When I try to connect to Cyber database the server send me this message

    Server Msg 927, Level 14 State 2

    Database Cyber Cannot Be opened. It is in the middle of restore ?

    Why the database cannot be opened ?

    Thank In advance

    Franklin

  7. #7
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Are you trying to open it from Enterprise Manager? I suspect that if you right-mouse click on Databases folder and select Refresh, - you won't get this error.

  8. #8
    Join Date
    Aug 2003
    Posts
    7

    Question help How Make Backup and Restore

    I'm trying to open from query analizer, because my application must be do it (the backup - restore) using transaq - sql.

    thanks
    franklin


    Originally posted by rdjabarov
    Are you trying to open it from Enterprise Manager? I suspect that if you right-mouse click on Databases folder and select Refresh, - you won't get this error.

Posting Permissions

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