Copying a database between servers



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 ?
.




Relevant Pages

  • RE: SQL server restore
    ... there is possiblly a database ... As for the SQL Server 2000 work on the Server A, ... restore the backups on it. ... restore from the backup). ...
    (microsoft.public.sqlserver.server)
  • Re: Restore database
    ... Initialize the backup device with INIT. ... My database is very small. ... Microsoft SQL Server Management Studio Express ... Restore failed for Server 'HOMEDEV\SQLEXPRESS'. ...
    (microsoft.public.sqlserver.setup)
  • RE: Backups have Shadow Copy Problems
    ... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
  • Re: restore permissions to a login
    ... restore the database. ... what about SQL Server installations that use ... > I have run into a situation that a 3rd party backup and restore solution ... > database roles and database_creators server role. ...
    (microsoft.public.sqlserver.server)
  • Re: Restore Database Dialog Shows Old Backup File Location
    ... Issues When a Database Is Moved Between SQL Servers ... for SQL Server ... we dropped all of our old backup devices and created new> ones pointing to the new drive. ... While reviewing the> restore database dialog information, I noticed that the old path> appeared under "Restore from" column. ...
    (microsoft.public.sqlserver.server)