Viewing 15 posts - 436 through 450 (of 748 total)
This is from error log of the SQL 2000 server:
2011-07-20 12:02:46.81 spid14 Starting up database 'CheckListDB'.
2011-07-20 12:02:46.84 spid5 Starting up database 'tempdb'.
2011-07-20 12:02:46.98...
July 20, 2011 at 1:00 pm
GilaMonster (7/20/2011)
Is that the DB's name? Is that the name that appears in the list? Are you running queries on the same server as that list...
July 20, 2011 at 12:57 pm
also tried
DBCC CHECKDB(CheckListDB_Data, REPAIR_ALLOW_DATA_LOSS)
failed with
Server: Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'CheckListDB_Data'. No entry found with that name. Make...
July 20, 2011 at 12:55 pm
GilaMonster (7/20/2011)
p.s. I seriously hope you're not doing this on a production server... It's insanely risky to do something like this on any server of importance.
No, not prod
July 20, 2011 at 12:54 pm
I run this: EXEC sp_resetstatus 'CheckListDB_Data'
it failed with:
Server: Msg 15010, Level 16, State 1, Procedure sp_resetstatus, Line 63
The database 'CheckListDB_Data' does not exist. Use sp_helpdb to show available databases.
July 20, 2011 at 12:53 pm
I just get in the server again, I swear I didn't see the database in the server list but now it appears there with Suspect status.
July 20, 2011 at 12:49 pm
Ninja's_RGR'us (7/20/2011)
Where are you located? Halifax??
I were from there, are you there now? 🙂
Halifax in Canada, bot Britain.
July 20, 2011 at 12:12 pm
GilaMonster (7/20/2011)
ZZartin (7/20/2011)
set allow updates on and then update sysdatabases and set the status to 36767 for that database.
Sorry if this is slightly off topic but isn't modifying system...
July 20, 2011 at 11:56 am
GilaMonster (7/20/2011)
halifaxdal (7/20/2011)
The DB is in suspect modeI tried to set the emergency mode but failed
Hang on, you first said the DB is not in the list, then you said...
July 20, 2011 at 11:55 am
GilaMonster (7/20/2011)
So the DB that you created is no longer there? (the one you created in order to swap the files out)
I created a new DB with the same name
I...
July 20, 2011 at 10:30 am
GilaMonster (7/20/2011)
Did the hack attach work (create new DB, stop SQL, swap files, start SQL)?Do you see the database in the list?
Is that it's full name?
Not in the list. I...
July 20, 2011 at 10:24 am
Ninja's_RGR'us (7/20/2011)
Is the db in the db list?Is the server case sensitive?
No, the DB is not in the list, that's the problem, it's not even in the SYSDATABASES
The server is...
July 20, 2011 at 10:22 am
GilaMonster (7/20/2011)
set allow updates on and then update sysdatabases and set the status to 36767 for that database.Then try to run a simple query against it.
I run the required...
July 20, 2011 at 10:08 am
GilaMonster (7/20/2011)
Well, yes, as I said "[the blog post]'s partially valid for SQL 2000, up until the set emergency which has to be done differently."
set allow updates on and then...
July 20, 2011 at 9:38 am
I created a new database with the same name, and then take it off line, and then replace with the damaged files, and then try to follow your steps in...
July 20, 2011 at 9:03 am
Viewing 15 posts - 436 through 450 (of 748 total)