Re: Database backup

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Is the problem resolved??


RESTORE DATABASE foo FROM DISK = 'x:\foo.bak'

--
Keith Kratochvil


"ykffc" <ykffc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7C668687-315A-40C0-9EDA-AFC716DDB212@xxxxxxxxxxxxxxxx
In our development system having MS SQL server running,
1) we already have made a database backup for one database. We can always
locate the backup file now (which is only one file, I believe)
2) then one of us delete (delete, not detach) the database under
Enterprise
Manager.

We found the system has removed th required mdf and log files of the
database we delete. Is there still away to recover the database, from the
backup data we make?

I hope the answer is yes, otherwise please provide any alternaive means.




.

Relevant Pages

  • Re: Offline defrag
    ... Take a look at system utilization during BLB, specifically disk IO/ps ... If BLB reports corrupt item, it indicates problem with backup software, not with mailbox. ... how can I do some test to make sure everything in exchange - disk speed, network link throughput, read/writes of disk system - is working fine without dismounting the stores. ... Since white space in the database does not belong to any item BLB can not read it. ...
    (microsoft.public.exchange.admin)
  • Mit isql mehrere DBs sichern und wiederherstellen
    ... Script habe ich soweit geschrieben aber nach dem ersten Backup steigt ... Hier mal mein Script: ...
    (microsoft.public.de.sqlserver)
  • Re: performance degradation during backup
    ... disk array died you would loose the database and your most recent backups. ... >>> Whenever I run database backup during normal operating ... The database size is 40GB and the backup ...
    (microsoft.public.sqlserver.server)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: RMAN restore of full backup fails completely
    ... You are not using a catalog database. ... You might have autobackup controlfile on, ... Your autobackup has been made *prior* to the backup! ... plus archivelog', when i try a restore on the other server however, the ...
    (comp.databases.oracle.server)