Re: MS SQL Database Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 05/14/04 

Date: Fri, 14 May 2004 08:56:39 -0400

> With SQL 7 and above, you can detach a database file from the server,
> copy/ftp the file to the destination server and attach it to the
destination
> SQL Server.
>
> Another way is to take a backup of the database, copy/ftp the backup file
to
> the remote server where you restore it to the destination server.
>
> If you need to make design changes to an existing database, the best
method
> is to run scripts containing DDL sql statements. However, there are free
> web-based administration tools which can be used to make design changes in
> much the same way that you would use Enterprise Manager:
> http://www.aspfaq.com/show.asp?id=2442

You can also use DTS to transfer a copy of the structure, or structure AND
data. However this often misses important things like IDENTITY properties,
constraints, defaults, etc.

A

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)