Re: Recover historic databases

From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 11/08/02 

From: "Jasper Smith" <jasper_smith9@hotmail.com>
Date: Fri, 8 Nov 2002 19:32:37 -0000

You can certainly script the entire databases using either
Enterprise Manager or SQLDMO and you can export
the data to flat files using DTS or bcp and reload using
BULK INSERT,bcp or DTS. 

-- 
HTH
Jasper Smith (SQL Server MVP)
Check out the PASS Community Summit - Seattle, the largest and only user
event entirely dedicated to SQL Server, November 19-22.
http://www.sqlpass.org/events/seattle/index.cfm
"J.L." <jl@nospam.es> wrote in message news:eJ8HfNyhCHA.2672@tkmsftngp09...
> Maybe it's not the correct newsgroup, let me know please.
>
> To prevent disaster recovery I do backups every day and it works fine, but
I
> want to archive historic databases to recover it if necessary. In the past
I
> used backup, but I had problems restoring backups when I had updated the
> version of SQL server.
>
> Are there any other methods of doing this, or is the problem with backups
> resolved?
> A collegue has told me that other databases have a type of 'export' that
> creates the SQL scripts with create table and insert methods, allowing you
> to recover the data in any SQL database. Does SQL 2000 have anything
> similar?
>
> Thanks in advance
>
>

Relevant Pages

  • Re: Help!! Trying to migrate data from one SQL to another?!?
    ... I came up to the window on the DTS Wizard which has the option to ... I can defend myself on PL/SQL but I am not much of a SQL Server ... The application performs a replication between databases but due to ...
    (microsoft.public.sqlserver.dts)
  • Re: Backup software for SBS2003 Standard
    ... I configured my test server with Windows Server 2003 and SCE, which runs on a SQL or MSDE database. ... As you say, I'd continue to do the online Exchange backups, maybe to file so they're included in the SP backups. ... For databases I care about, I do Enterprise Manager backups to file a few times a day, and those get included in the SP backups as well. ...
    (microsoft.public.windows.server.sbs)
  • Re: restoring a portal
    ... > If you are using SQL Server as the Database back end, ... > existing Databases assocoated with Portal, ... > SQL backups running you could also try to restore fro SQL also. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Problems with SQL 2000 with SP3
    ... Have you considered uninstalling and reinstalling SQL Server completely? ... Then it should just be a matter of restoring your user databases, ... what you have backups for anyway... ... > second partition is SQL and its databases. ...
    (microsoft.public.sqlserver.server)
  • Recover historic databases
    ... To prevent disaster recovery I do backups every day and it works fine, ... want to archive historic databases to recover it if necessary. ... version of SQL server. ...
    (microsoft.public.sqlserver.security)