Post reply

Copy/moving backup files

  • October 21, 2004 at 7:10 pm

    #361371

    Hi,

    how do you copy/move database backup files between servers - response greatly appreciated

    Thanks

  • October 21, 2004 at 9:03 pm

    #527571

    backup files are just files. I'm not sure exactly what you are asking for.

    Wes

  • October 22, 2004 at 2:04 am

    #527595

    For backup files use the copy past mechanism trough your LAN. ( backup and restore )

    This same goes for the datafiles after ( and before ) attaching and detaching.

    How easy it can get...

    GKramer

  • October 22, 2004 at 7:42 am

    #527645

    I have to restore database residing on server1 to server2, so I have to first copy the backup file from server1 to server2 inorder to restore, so how do we copy the backup file between servers

  • October 22, 2004 at 2:15 pm

    #527714

    As Wes said, they're just files.  Find the backup file from the date and time that you want to copy.  It will have an extension of .bak with a DB name and number in front of it.  It will look something like this from Windows Explorer:

    'mydb_db_200410210200.BAK'

    where 'mydb' is the name of your database.  Using Windows Explorer, right click on this, and select Copy.  Map a drive to the server2  where you want to restore, migrate to the appropriate folder, right click and select Paste.

    Now you have a copy of the backup file on the second server but you still have to restore it.  If your database names and file paths are exactly the same you can simply perform a restore from Enterprise Manager by browsing to the file you just copied.  If there are any differences in either the file names, drive letters and/or file paths on server2, you'll need to perform a restore from Query Analyzer using the 'from disk' and 'with replace' options.  For more information on these parameters and how to use them, please see Books On Line. 

    You're not quite done yet.  If you do not have the exact same users on server1 and server2, you'll also need to synchronize the logins so you that can assign and modify their database access.  Microsoft has published information on this process here:  http://www.microsoft.com/downloads/details.aspx?familyid=5fe5c502-fd2f-4773-a29e-8ae505060cae&displaylang=en  that should help you with this.

    Hope this helps and best of luck.

     

     

    My hovercraft is full of eels.

  • October 22, 2004 at 7:39 pm

    #527730

    I appreciate your help, thanks a lot

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply