Re: Backup / restore question

From: Ray Higdon (sqlhigdon_at_nospam.yahoo.com)
Date: 03/06/04

  • Next message: Bob P.: "new MSDE install fails with "instance name specified is invalid"" 
    Date: Sat, 6 Mar 2004 14:38:05 -0500

    If all you have is the full backup and the old db is toast then no. You
    might be able to do something with third party tool help such as Lumigent
    Log Explorer depending on a few factors. 

    -- 
Ray Higdon MCSE, MCDBA, CCNA
---
<--> wrote in message news:%23xrmzy6AEHA.3788@TK2MSFTNGP10.phx.gbl...
> I had a SQL server with some harddrive problems.  So, a full backup was
made
> (manually using Enterprise Manager) and restored in a new machine
> successfully using Enterprise Manager (the option Leave Database
> Operational. No Additional Transaction Logs Can Be Restored was selected)
>
> If the only backup available is the last Full backup, is it possible to
ever
> roll back some of the last changes made in the old machine before the Full
> Backup ?
>
> Thanks for your help.
>
>
  • Next message: Bob P.: "new MSDE install fails with "instance name specified is invalid""

    Relevant Pages

    • Re: Backup confusion
      ... You can view Devices in Enterprise Manager by looking under {Management], ... You may wish to seek out more information about BACKUP DEVICEs in Books On ... Most good judgment comes from experience. ... device and backup a database I assume that in both cases the ...
      (microsoft.public.sqlserver.tools)
    • Re: sql server 2000 backup and restore
      ... These are the jobs thatare run on our server. ... running under Enterprise Manager. ... Step 3 (Full Backup of MHC) ... >> restore script to this website next week. ...
      (microsoft.public.sqlserver.setup)
    • Re: SQL Database backup
      ... do - online Enterprise Manager backup to disk, ... Is this what most people use to backup their SQL databases? ... came with SBS Premium (the same one you used to install SQL). ... SQL installer on your XP desktop, selecting Enterprise Manager as the ...
      (microsoft.public.windows.server.sbs)
    • Re: Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K
      ... I don't have a problem creating the T-SQL commands, ... Enterprise Manager to do more than create dbs is where I get lost. ... recent backup HAS to succeed before it'll delete the older one. ...
      (comp.databases.ms-sqlserver)
    • Tape Drive Problem.
      ... driver SEAGATE 9SP40-000. ... I try to make the backup but instead of using de Enterprise Manager using ... I also installed the SQL Server after the Tape Drive. ...
      (microsoft.public.sqlserver.setup)
    Loading