Re: Copying a database between servers

I'm not sure about SQL7.0, but SQL2000 will without any problems backup and
restore databases from other servers. In 2000 you can backup to an UNC path
or a local drive and the same goes for the restore. Attaching and Detaching
the files as DAvid explains will work, but you have to remember that it's an
offline operation where your source database will be unavailable while you
are copying the files. Also there're more steps to be done than if you just
backup the database and then restore it on the new server.

I'm not an expert in doing this from EM, but maybe others can help you with
that. I'd suggest that you look up the Backup and Restore command in Books
On Line and then do it from Query Analyzer - that will give you more options
and flexibility.

Regards
Steen

Edward Diener wrote:
> David Gugick wrote:
>> Edward Diener wrote:
>>
>>> Is backup and restore the best way to simply copy a database from
>>> one SQL Server 7.0 database with 'select' access to another SQL
>>> Server 7.0 database on another machine with 'all' access ? Or is
>>> there another easier way with the SQL Server 7.0 tools ?
>>
>>
>> You could try detaching and reattaching the database using
>> sp_detach_db and sp_attach_db / sp_attach_single_file_db. You would
>> need to stop the server and copy the data and log files and attach
>> the copy. You wouldn't need to detach in this case. When you attach
>> the copy, you'll likely get an error related to the log file since
>> the data file points to a log file in use by the original database.
>> SQL Server 2000 will create a new log file and attach. I'm not sure
>> if SQL 7 will do the same, but it likely will.
>
> Can this detach/attach be done with Enterprise Manager and, if not,
> how do I do it ?
>
> I tried to backup and restore but SQL Server 7 would only allow me to
> backup on the machine where the server resides in which is the
> database I want to backup, and would only allow me to restore from
> the machine where is the server to which I wanted to restore the
> database. Now that is what I call flexibility ! Why I can not backup
> and restore to and from any machine to which I am connected and have
> directory rights I do not know.


.

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: How to restore edb & stm files from bkf backup file on another exc
    ... copied to a different storage group on the same server or to a different ... On production server successfully backup information ... Restore Status ... Failed to find a database to restore to from the Microsoft ...
    (microsoft.public.exchange.admin)
  • 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: Adventures in Server restore
    ... >> I thought I'd pass on my experience in bringing back an exchange server ... >> restore exercises, a real restore turned out to be far from easy. ... I'm not sure what happened (but a online backup was going ... >> persists then please restore the database from a previous backup. ...
    (microsoft.public.exchange.admin)
  • Re: WSS 3.0 Backup Problems
    ... I was able to resolve this problem by configureing my SharePoint Server not to automatically adjust for Day light savings time. ... My backup used to take 10 minutes. ... STSADM is enough to restore a site to a new server. ... the configuration database to restore a site to a new server. ...
    (microsoft.public.sharepoint.windowsservices)