Recover historic databases

From: J.L. (jl@nospam.es)
Date: 11/08/02 

From: "J.L." <jl@nospam.es>
Date: Fri, 8 Nov 2002 13:43:30 +0100

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: 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)
  • Restore sharepoint site
    ... yesterday and I've been trying to recover it. ... content databases using the SQL backup tools so I have recent backups. ... Admin -- there are no databases listed in manage content databases. ...
    (microsoft.public.windows.server.sbs)
  • Please Help: How to restore sharepoint database
    ... yesterday and I've been trying to recover it. ... content databases using the SQL backup tools so I have recent backups. ... Admin -- there are no databases listed in manage content databases. ...
    (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: I need backup Master data base?
    ... You need backups of database you want to be able to recover. ... disks, how would you get the system back up and running as ... your system databases and your user ...
    (microsoft.public.sqlserver.security)