Viewing 15 posts - 301 through 315 (of 388 total)
I do agree with you guys, we need to find a problem. But how good is keeping database offline\Suspect mode and looking for solution and keeping business down for hours...
February 16, 2010 at 2:45 pm
Alvin Ramard (2/16/2010)
GT-897544 (2/16/2010)
sqldba551 (2/16/2010)
As last 3 days back my server got hardware failure,my databases went into suspect mode,i have tried to take it to online by...
February 16, 2010 at 2:40 pm
GilaMonster (2/16/2010)
GT-897544 (2/16/2010)
And by dbcc I mean with “DBCC CHECKTABLE” REPAIR_REBUILD. If that did not complete successful after two or three times I would then use “REPAIR_ALLOW_DATA_LOSS” option.
Oh for crying...
February 16, 2010 at 2:35 pm
Lynn Pettis (2/16/2010)
GT-897544 (2/16/2010)
Bru Medishetty (2/16/2010)
GT-897544 (2/16/2010)
Bru, did you ever see Database in supsect mode as a DBA, if so what did you do to fix it?:hehe:EnjoY!
I liked Gail's...
February 16, 2010 at 2:28 pm
sqldba551 (2/16/2010)
As last 3 days back my server got hardware failure,my databases went into suspect mode,i have tried to take it to online by SET IT FIRST...
February 16, 2010 at 2:24 pm
Bru Medishetty (2/16/2010)
GT-897544 (2/16/2010)
Bru, did you ever see Database in supsect mode as a DBA, if so what did you do to fix it?:hehe:EnjoY!
I liked Gail's witty reply and...
February 16, 2010 at 2:19 pm
sqldba551 (2/16/2010)
As last 3 days back my server got hardware failure,my databases went into suspect mode,i have tried to take it to online by SET IT FIRST...
February 16, 2010 at 2:12 pm
GilaMonster (2/16/2010)
GT-897544 (2/16/2010)
Bru Medishetty (2/16/2010)
GilaMonster (2/16/2010)
GT-897544 (2/16/2010)
Extract all the objects using SSIS package, to be in safe side.
Do you have the vaguest idea what you're talking about here?
A suspect...
February 16, 2010 at 2:05 pm
Alvin Ramard (2/16/2010)
GT-897544 (2/16/2010)
Extract all the objects using SSIS package, to be in safe side.EnjoY!
huh?? Sounds like a developer trying to do a DBA's job.
Please try to change your...
February 16, 2010 at 1:59 pm
Bru Medishetty (2/16/2010)
GilaMonster (2/16/2010)
GT-897544 (2/16/2010)
Extract all the objects using SSIS package, to be in safe side.
Do you have the vaguest idea what you're talking about here?
A suspect database is...
February 16, 2010 at 1:50 pm
Lynn Pettis (2/16/2010)
GT-897544 (2/16/2010)
what are you trying to achieve here? Why do you need both servers as principal?EnjoY!
Servers are not principal, databases are. Database Mirroring is at the...
February 16, 2010 at 1:20 pm
Extract all the objects using SSIS package, to be in safe side.
EnjoY!
February 16, 2010 at 1:17 pm
homebrew01 (2/16/2010)
If you use the wizard, you can choose to append to or delete the existing data. With linked server, manually delete the existing data first if you need to.
I...
February 16, 2010 at 1:11 pm
Client tools, SSMS will be installed by default if you did not change anything, if you had selected SSRS Report server configuration manager will be installed else won't be installed.
Go...
February 16, 2010 at 1:07 pm
Viewing 15 posts - 301 through 315 (of 388 total)