Viewing 15 posts - 7,921 through 7,935 (of 49,552 total)
Grant Fritchey (9/4/2014)
You never know. I get stumped all the time. That's why Gail's here.
Wha?
Well, at least I have a purpose in life...
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
September 5, 2014 at 2:47 am
AppSup_dba (9/4/2014)
Error log
During undoing of a logged operation in database '', an error occurred at log record ID (xx)
Database was shutdown due to...
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
September 5, 2014 at 2:29 am
What's a DCS service?
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
September 5, 2014 at 2:26 am
The transaction log is full due to replication.
If you have transactional replication configured, make sure the log reader is running.
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
September 5, 2014 at 2:25 am
http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
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
September 4, 2014 at 7:46 am
To start with, don't use multi-statement table-valued functions. They're notorious performance problems, especially when joined to other tables. That's because of the lack of stats on the table variables.
Try converting...
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
September 4, 2014 at 7:30 am
LadyDardar (9/4/2014)
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
September 4, 2014 at 6:38 am
LadyDardar (9/4/2014)
It was recommended to switch to either simple or bulk.
Probably recommended by someone who doesn't know what recovery models do...
Does your system require point-in-time recovery in the case...
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
September 4, 2014 at 6:09 am
LadyDardar (9/4/2014)
i'm concerned that I run the risk of corrupting my db everything I switch from full recovery to simple mode.
Um....
SQL does not corrupt its own databases. Corruption is...
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
September 4, 2014 at 6:05 am
Every single data modification is applied to the secondary.
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
September 4, 2014 at 4:48 am
AppSup_dba (9/4/2014)
4078 transactions rolled forward in database 'database' (9). This is an informational message only. No user action is required.
Recovery of database 'database' (9) is 4% complete (approximately 146199...
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
September 4, 2014 at 2:36 am
It shouldn't be, I did say that.
Is the mirroring failing over?
Are there any useful messages in the error log?
Is the log on the mirror side also filling up?
Are you sure...
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
September 4, 2014 at 12:46 am
Eirikur Eiriksson (9/3/2014)
BTW, the bouncing is easy, it's the catching of the server exceptions which is tricky
You just need a large net. What's so difficult about that?
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
September 3, 2014 at 3:01 pm
CheckTable isn't all that checkDB does. Try CheckAlloc and CheckCatalog.
Have you tried the restart that the message mentions?
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
September 3, 2014 at 12:11 pm
I don't even know if it'll work though. Also may cause problems when you go to deploy scripts. SQL treats 'table doesn't exist' and 'permission denied' the same way. You...
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
September 3, 2014 at 8:15 am
Viewing 15 posts - 7,921 through 7,935 (of 49,552 total)