Viewing 15 posts - 32,686 through 32,700 (of 49,552 total)
jpage01 (5/30/2010)
Msg 7909, Level 20, State 1, Line 1The emergency-mode repair failed.You must restore from backup.DBNAME
That says it all. Emergency mode is the very last resort, if it fails, there's...
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
May 30, 2010 at 11:12 pm
Ok, I give up. What's a clustering agent?
http://www.sqlservercentral.com/Forums/Topic930164-146-1.aspx
Who's got the crystal ball?
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
May 30, 2010 at 11:11 am
Windows clustering? As in fail-over clustering?
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
May 30, 2010 at 11:09 am
Come again? What do you mean by 'clustering agent'?
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
May 30, 2010 at 10:59 am
I'm working with a client at the moment where there's no DBA at all and never has been. Plan is that I do triage and get the environment back into...
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
May 30, 2010 at 10:58 am
This one's not much better...
http://www.sqlservercentral.com/Forums/Topic929458-357-1.aspx
If you have a 2 TB database and don't know how to plan backup and restore strategies, there's a bigger problem there.
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
May 30, 2010 at 10:53 am
viswanath09 (5/27/2010)
which backup and restore strategy used for the database size above 2TB.
I would really hope that if you have 2 TB databases, you have a senior DBA who's...
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
May 30, 2010 at 10:51 am
hxkresl (5/30/2010)
Thanks for replying Gilamonster.I have been saving to the same trans log using NOINT. so, there's only one trans file.
I would strongly suggest that you change your...
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
May 30, 2010 at 10:50 am
From the error, I'd say that log backup was taken before the Diff, which means it's not needed for the restore. You should start with the first log backup after...
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
May 30, 2010 at 3:40 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in the...
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
May 30, 2010 at 3:39 am
Sourav-657741 (5/29/2010)
sp_spaceused only takes the 'table name' as parameter input. Can I get something similar results for SPs?
Not really, and I honestly don't see why you'd need to. Tables store...
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
May 30, 2010 at 3:34 am
What do you mean by size? No of characters? No of lines? Something else?
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
May 29, 2010 at 8:28 am
Do you have a DBA there, or someone that knows SQL well?
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
May 29, 2010 at 2:15 am
WayneS (5/28/2010)
GilaMonster (5/28/2010)
It was. I did the exchange rate calc in my head and messed it up. :blush: Fixed.
That's better! 😀
For those that didn't see it... she was offering her...
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
May 28, 2010 at 4:18 pm
TravisDBA (5/28/2010)
I feel every company should hire citizens first before immigrants regardless of country"
I'm so glad that isn't a law where I live. Though, the way the government is going...
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
May 28, 2010 at 2:31 pm
Viewing 15 posts - 32,686 through 32,700 (of 49,552 total)