Help Crash!!

From: Bradley M. Small (BSmall_at_XNOSPAMXmjsi.com)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 11:09:08 -0400

Computer crashed quite severely, was able to recover the C:\MSSQL7\Data
directory with all of the MDF and LDF files in it for the databases. Backups
directory was completely lost and as I understand it there are no outside
copies of backups. How if it is at all possible does one get these mounted
in such a way that they can be recovered in a new machine?

Relevant Pages

  • 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)
  • 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)
  • Re: Recover Databases after OS Crash
    ... You can try sp_attach_db using the .mdf and ldf files. ... > WE had a OS Crash and now we have to recover the databases. ... > Is there a way to recover the user and system databases. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Maintenance Plans and Atomic Backups of a Set of Databases
    ... Actually, the maintenance plans are still a valuable method of running backups, though you can also create scripts for them. ... Yes, the documentation indicates that STOPATMARK should work for you, provided that you update all 12 databases inside the same marked transaction. ... However, no matter when you decide to set the transaction marks, it is the restore databases that will make use of them. ...
    (microsoft.public.sqlserver.tools)
  • Re: Backing up to hard disk - how large?
    ... > "Kevin Weilbacher" wrote in message ... >> As far as backups to recover a particular file, ... >> tape or disk backup! ... >>> several backups from successives days in case someone needs to ...
    (microsoft.public.backoffice.smallbiz2000)