Viewing 15 posts - 421 through 435 (of 748 total)
Ignacio A. Salom Rangel (7/21/2011)
halifaxdal (7/21/2011)
1. stop the server and deleted the old DB
2. start the server and create it again
3. take it off...
July 21, 2011 at 8:25 am
I got this error message:
Error 5173: Cannot associate files with different databases.
Could not restart database 'CheckListDB', reverting back to old status.
ALTER DATABASE statement failed.
Log file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\CheckListDB_Log.LDF' does...
July 21, 2011 at 8:07 am
I am doing everything again from scratch:
1. stop the server and deleted the old DB
2. start the server and create it again
3. take it off line
4. swap the DB files
5....
July 21, 2011 at 8:02 am
Ignacio A. Salom Rangel (7/21/2011)
Try to do it all over again and see if it works this time, something may have happened since yesterday.
Gail, are you on the same page...
July 21, 2011 at 7:49 am
GilaMonster (7/21/2011)
And that's after setting the status to 32767?
Yes, yesterday I changed the status with success
July 21, 2011 at 7:31 am
GilaMonster (7/21/2011)
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...
July 21, 2011 at 7:19 am
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...
July 20, 2011 at 2:41 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...
July 20, 2011 at 2:35 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...
July 20, 2011 at 2:18 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:08 pm
success!
What's the next step? Thanks.
July 20, 2011 at 1:57 pm
Ninja's_RGR'us (7/20/2011)
halifaxdal (7/20/2011)
Ninja's_RGR'us (7/20/2011)
Please run the checkdb command (DO NOT allow data loss) and post the results here.
How to run (DO NOT allow data loss)?
July 20, 2011 at 1:53 pm
Ninja's_RGR'us (7/20/2011)
Now you just need...
July 20, 2011 at 1:46 pm
Thanks Ninja.
I didn't know that Gail was unhappy with this. Gail: if you are still reading this post, I want to say sorry to you, being tired I don't know...
July 20, 2011 at 1:29 pm
Ninja's_RGR'us (7/20/2011)
halifaxdal (7/20/2011)
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...
July 20, 2011 at 1:02 pm
Viewing 15 posts - 421 through 435 (of 748 total)