Re: Restoring a db from an OS file
From: Brian Moran (brian_at_solidqualitylearning.com)
Date: 10/25/04
- Next message: Brian: "Multiple Databases vs a Few"
- Previous message: Dan D.: "RE: linked server permissions"
- In reply to: MGeles: "Re: Restoring a db from an OS file"
- Next in thread: MGeles: "Re: Restoring a db from an OS file"
- Reply: MGeles: "Re: Restoring a db from an OS file"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 25 Oct 2004 09:34:14 -0400
Simply making a OS level copy of the mdf and other DB files is not really
correct. If the db was not detached first... it's possible a reattach might
have problems. Is the data important? If yes... then in situatioins like
this I woudl encourage you to open a call to MS PSS. It's about $200 or
something like that. You might very well be able to get good help here on
the newsgroups. But it's my opinion that recovery of 'real' business data is
always best done by either someone who already has the direct knowledge or
with a call to PSS.
-- Brian Moran Principal Mentor Solid Quality Learning SQL Server MVP http://www.solidqualitylearning.com "MGeles" <michael.geles@thomson.com> wrote in message news:F0188A58-1804-4EAF-9509-66A8D3FA214F@microsoft.com... > The only "backup" that we have was made by making a copy of the > <database_name>.mdf & <database_log>.ldf files, not by doing an actual > database backup. > > We had RAID 5 set up on the db servers (1 Primary & 2 backup). 1 disk went > bad the primary and the server went down. We replaced the bad disk, but now > there is one db on the primary that is marked as suspect. A second is not > labled as suspect, but when I try to look at the tables through Enterprise > Manager, EM freezes and I need to kill it. > > On each of the backups, there are 3 databases that we are unable to access > right now. The Enterprise manager shows the word "loading" next to 2 of the > dbs and "suspect" next to the third. > > We did have log shipping is place to 2 backup servers, but it looks like > this hung when the disk went bad on the primary. > > Does this look like a good situation to detach the DBs and build new ones? > > Thanks > Mike > > > "Keith Kratochvil" wrote: > > > What edition of SQL Server? > > If you are lucky and you are running SQL Server 7 or higher then yes it > > might be possible. You may have to use sp_attach_db to attach the database > > files to the database server. > > > > You mention that you have a "good" copy of the file. How was the backup > > taken? What makes the current database "bad?" > > > > Did you detach the database before taking the file backup? You detach > > databases via the sp_detach_db command. NOTE: this removes your database > > from the database server so this is not exactly the best method for taking a > > backup. > > > > The best method is using the T-SQL BACKUP command to backup the database to > > a file that can be backed up to tape, copied to other servers..... > > > > -- > > Keith > > > > > > "MGeles" <michael.geles@thomson.com> wrote in message > > news:0426CE36-8F73-4A3A-95A4-A94E01F320FF@microsoft.com... > > > Is it possible to restore a db by replaceing the db's os file with a good > > > copy of the os file. > > > -- > > > MG > > > >
- Next message: Brian: "Multiple Databases vs a Few"
- Previous message: Dan D.: "RE: linked server permissions"
- In reply to: MGeles: "Re: Restoring a db from an OS file"
- Next in thread: MGeles: "Re: Restoring a db from an OS file"
- Reply: MGeles: "Re: Restoring a db from an OS file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
