July 20, 2011 at 2:02 pm
Can't be?!?!?
How big is the DB? How much data was there in it before the accident happened?
July 20, 2011 at 2:08 pm
Ninja's_RGR'us (7/20/2011)
Can't be?!?!?How big is the DB? How much data was there in it before the accident happened?
not big at all AFAIK
I don;t know how much data stored there
July 20, 2011 at 2:11 pm
halifaxdal (7/20/2011)
Ninja's_RGR'us (7/20/2011)
Can't be?!?!?How big is the DB? How much data was there in it before the accident happened?
not big at all AFAIK
I don;t know how much data stored there
Please go ask to the owner or users. The good news is that we might have been trying to restore something that wasn't critical.
Maybe the only "value" was some sps and views..
July 20, 2011 at 2:18 pm
Ninja's_RGR'us (7/20/2011)
halifaxdal (7/20/2011)
Ninja's_RGR'us (7/20/2011)
Can't be?!?!?How big is the DB? How much data was there in it before the accident happened?
not big at all AFAIK
I don;t know how much data stored there
Please go ask to the owner or users. The good news is that we might have been trying to restore something that wasn't critical.
Maybe the only "value" was some sps and views..
No, I don't think there is anything non-critical, besides I have a very tough and non-understandable guy on top of me. So I won't give up any hope, and I specially thank you all guys for the kind help.
July 20, 2011 at 2:25 pm
halifaxdal (7/20/2011)
Ninja's_RGR'us (7/20/2011)
halifaxdal (7/20/2011)
Ninja's_RGR'us (7/20/2011)
Can't be?!?!?How big is the DB? How much data was there in it before the accident happened?
not big at all AFAIK
I don;t know how much data stored there
Please go ask to the owner or users. The good news is that we might have been trying to restore something that wasn't critical.
Maybe the only "value" was some sps and views..
No, I don't think there is anything non-critical, besides I have a very tough and non-understandable guy on top of me. So I won't give up any hope, and I specially thank you all guys for the kind help.
So what did he tell you was in the db?
What application connects to it?
When did he notice the break?
July 20, 2011 at 2:35 pm
It is actually just one of the many DBs that went down. All the others, damaged perm or recovered already. I am just trying to work on this last one.
I don't know what the DB is for, that's not what I should know, and so as the database structure, schema...... All they want me to do is get it working, and while it was working, no one even know I am the server's tech contact.
You know, this is the life of DBA:crying::crying::crying::crying::crying:
July 20, 2011 at 2:38 pm
Do you happen to have a back up you can recover and see if that will work well enough if they don't want to give you more details?
July 20, 2011 at 2:38 pm
halifaxdal (7/20/2011)
It is actually just one of the many DBs that went down. All the others, damaged perm or recovered already. I am just trying to work on this last one.I don't know what the DB is for, that's not what I should know, and so as the database structure, schema...... All they want me to do is get it working, and while it was working, no one even know I am the server's tech contact.
You know, this is the life of DBA:crying::crying::crying::crying::crying:
It's a shame, I just hope Gail as Som emagic trick to solve this. I'm out of ideas but she's the real expert between the 2 of us.
July 20, 2011 at 2:41 pm
Sorry Ninja, get to leave now, thank you so much for your time helping me the whole day, I like to meet you one day in Montreal and pay you a lunch or something like that.
I will be back tomorrow morning (Eastern time 9am or so), I hope we can have Gail joining us, and of course hope I can at least kind of recover the DB, if not completely.
July 20, 2011 at 2:44 pm
ZZartin (7/20/2011)
Do you happen to have a back up you can recover and see if that will work well enough if they don't want to give you more details?
She stated she didn't in the original post. Maybe it's worth a 2nd look.
Can you run this on the prod db to see if there's a backup someone may have missed?
SELECT
bs.backup_set_id
, bf.physical_drive
, bf.physical_name
, bs.backup_set_uuid
, bs.media_set_id
, bs.first_family_number
, bs.first_media_number
, bs.last_family_number
, bs.last_media_number
, bs.catalog_family_number
, bs.catalog_media_number
, bs.position
, bs.expiration_date
, bs.software_vendor_id
, bs.[name]
, bs.description
, bs.[user_name]
, bs.software_major_version
, bs.software_minor_version
, bs.software_build_version
, bs.time_zone
, bs.mtf_minor_version
, bs.first_lsn
, bs.last_lsn
, bs.checkpoint_lsn
, bs.database_backup_lsn
, bs.database_creation_date
, bs.backup_start_date
, bs.backup_finish_date
, bs.[type]
, bs.sort_order
, bs.code_page
, bs.compatibility_level
, bs.database_version
, bs.backup_size
, bs.database_name
, bs.server_name
, bs.machine_name
, bs.flags
, bs.unicode_locale
, bs.unicode_compare_style
, bs.collation_name
, bs.is_password_protected
, bs.recovery_model
, bs.has_bulk_logged_data
, bs.is_snapshot
, bs.is_readonly
, bs.is_single_user
, bs.has_backup_checksums
, bs.is_damaged
, bs.begins_log_chain
, bs.has_incomplete_metadata
, bs.is_force_offline
, bs.is_copy_only
, bs.first_recovery_fork_guid
, bs.last_recovery_fork_guid
, bs.fork_point_lsn
, bs.database_guid
, bs.family_guid
, bs.differential_base_lsn
, bs.differential_base_guid
, bf.backup_set_id
, bf.first_family_number
, bf.first_media_number
, bf.[filegroup_name]
, bf.page_size
, bf.file_number
, bf.backed_up_page_count
, bf.file_type
, bf.source_file_block_size
, bf.file_size
, bf.logical_name
, bf.state
, bf.state_desc
, bf.create_lsn
, bf.drop_lsn
, bf.file_guid
, bf.read_only_lsn
, bf.read_write_lsn
, bf.differential_base_lsn
, bf.differential_base_guid
, bf.backup_size
, bf.filegroup_guid
, bf.is_readonly
, bf.is_present
FROM
msdb.dbo.backupset bs
INNER JOIN msdb.dbo.backupfile bf
on bs.backup_set_id = bf.backup_set_id
WHERE
bs.[type] = 'D'
AND bs.database_name = 'Db name goes here'
July 20, 2011 at 3:27 pm
If checkdb ran, I'd make a backup first. See if that works.
Beyond that, I'll let Gail help out. She's more experienced in this area.
July 20, 2011 at 3:38 pm
Steve Jones - SSC Editor (7/20/2011)
If checkdb ran, I'd make a backup first. See if that works.Beyond that, I'll let Gail help out. She's more experienced in this area.
The problem is that the list of tables returned sweet nothing. Looks like an old master db renamed or something like that.
We might have successfully revived the db but there's no way to know without more info from the client which is apparently not very cooperative at this point!
July 21, 2011 at 1:18 am
Ninja's_RGR'us (7/20/2011)
DBCC CHECKDB('CheckListDB') WITH NO_INFOMSGS, ALL_ERRORMSGS
halifaxdal (7/20/2011)
success!What's the next step? Thanks.
Err, there's no way CheckDB can run clean normally if the run with repair fails. Did you run it for the right DB? That command will run for the current DB, to be sure, rather specify the DB name.
DBCC CHECKDB('CheckListDB') WITH NO_INFOMSGS, ALL_ERRORMSGS
Also, if querying a specific table failed with 'cannot open database', querying sysobjects would return the same error. Double check the context of the queries, it sounds like you're running them from the wrong database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2011 at 7:19 am
GilaMonster (7/21/2011)
Ninja's_RGR'us (7/20/2011)
DBCC CHECKDB('CheckListDB') WITH NO_INFOMSGS, ALL_ERRORMSGShalifaxdal (7/20/2011)
success!What's the next step? Thanks.
Err, there's no way CheckDB can run clean normally if the run with repair fails. Did you run it for the right DB? That command will run for the current DB, to be sure, rather specify the DB name.
DBCC CHECKDB('CheckListDB') WITH NO_INFOMSGS, ALL_ERRORMSGSAlso, if querying a specific table failed with 'cannot open database', querying sysobjects would return the same error. Double check the context of the queries, it sounds like you're running them from the wrong database.
Thanks for coming back Gail.
Why this time I don't get success message when I run this:
DBCC CHECKDB('CheckListDB') WITH NO_INFOMSGS, ALL_ERRORMSGS
Server: Msg 945, Level 14, State 2, Line 1
Database 'CheckListDB' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
There is no this DB for me to connect to because it's not in the list in QA, in EM, it shows differently this time: Loading\Suspect\Offline
Thank you again for your help.
July 21, 2011 at 7:26 am
And that's after setting the status to 32767?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 61 through 75 (of 130 total)
You must be logged in to reply to this topic. Login to reply