Re: transfer database between two servers which don't want to talk

There are two advantages to using the backup/restore process. The first is that the backup process (using SQL Server Agent) does not require taking the source database off line. You *will* have to take the target database off line....

The second is that it's a smaller file and will transfer quicker.... Plus you have a good backup of the db.


Regards,
Hank Arnold

Alan Baljeu wrote:
I need to copy tables, and views. I would like to copy roles and stored
procedures, but I can rebuild those if absolutely necessary. Can anyone
help?
Data, stored procs, views, trigger, all this you have in a backup. Make a
full backup and send this file per FTP, mail whatever you want to the other
computer. On the target computer create a new empty database and make a
restore, using this backup. What you have to do by hand is the security
part (login, grants, ..). Easiest way is doing all with Enterprise Manager.

Thanks for the suggestion. After investigating this, I found an even easier approach: I took the database offline, copied the database files, and then brought the copies online at the new computer. This works perfectly.


.

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: RMAN restore of full backup fails completely
    ... You are not using a catalog database. ... You might have autobackup controlfile on, ... Your autobackup has been made *prior* to the backup! ... plus archivelog', when i try a restore on the other server however, the ...
    (comp.databases.oracle.server)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... newsgroups so that they can be resolved in an efficient and timely manner. ...
    (microsoft.public.windows.server.sbs)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)